Skip to content

Managing and tracking inventory of a computer store using Microsoft SQL Server

Notifications You must be signed in to change notification settings

chinh-chinh/Inventory-Management-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Inventory Management System

Overview

A project to manage and track the inventory of a computer store using Microsoft SQL Server. The system allows for efficient management of inventory data, including adding new items, updating stock levels, and generating reports.

Entity Relationship Diagram (ERD)

ERD

Database Design

  • Schema: The database consists of tables for products, categories, suppliers, customers, and transactions. Schema
  • Normalization: Ensured third normal form (3NF) to reduce data redundancy and improve data integrity.