The project goal was to design a relational database management system that contains product information and keeps track of products as it moves through the business channels.
- Microsoft SQL Server Management Studio 18
List of Features
- Normalized database to reduce redundancy
- Transaction Log to trace the movement and location of individual products from the company to customers
- Return Log to trace the movement and location of individual products from customers to the company
To-do list:
- Incorporate all stored procedures into a single stored procedures
- Create a trigger that automatically inserts new records as the inventory tables update
Requirements Microsoft SQL Server Management Studio
Steps to pulling repo to a directory
- Create a directory that will store the project data
- Locate that directory in Git Bash
- Type git init and press Enter
- Type git pull https://github.com/210104-msbi-reston/Ricki-Nguyen-P1.git
- Open Microsoft SQL Server Management Studio
- Go to File in the Tool Bar
- Open a File
- Select all the SQL scripts located in the directory
- Execute all the SQL Scripts
Stored Procedures
- proc_updatePLogCPToSeller
- proc_updatePLogDistToSDist
- proc_updatePLogPHToDist
- proc_updatePLogSDistToCP
- proc_updateRLogCPToSDist
- proc_updateRLogDistToPH
- proc_updateRLogSDistToDist
- proc_updateRLogSellerToCP
Functions
- func_calculateCPToSellerPrice
- func_calculateDistToSDistPrice
- func_calculatePHToDistribPrice
- func_calculateSDistToCPPrice
Views
- view_ProductReturnHistory
- view_ProductTransferHistory
This project uses the following license: