This project aims to replicate the database structure and functionalities of Fritolay. Information about their operational workflow was gathered through communication with the company.
A comprehensive list of all data constraints is documented in the Constraints.pdf file within this repository.
Microsoft SQL Server is employed as the primary database management system for this project.
Each table within the database adheres to the following principles:
- Indexes
- Primary Keys
- Foreign Keys
- Unique Constraints
- Identity Columns
- Check Constraints
- Default Values
- Computed Columns
- Triggers
- Stored Procedures
For a comprehensive understanding of the project's implementation and design choices, please refer to the Report.pdf file located within this repository.