sql database for pizza shop

• SQL/T-SQL
• EER
• UML

This university project involved designing a complete database system for a pizza outlet transitioning from manual to digital record-keeping. The goal was to create an efficient, normalized, and scalable database structure tailored to the shop's operations. The project followed a structured methodology, broken into modules including requirements analysis, conceptual design, logical design, and physical implementation.

The process began with a detailed requirements analysis, where data requirements, transaction needs, and business rules were identified. This led to the creation of an Enhanced Entity-Relationship (EER) diagram and a comprehensive data dictionary detailing all entities, attributes, and relationships. The logical design phase involved converting the EER model into a normalized relational schema. The database was normalized up to Boyce-Codd Normal Form (BCNF) to ensure data consistency and eliminate redundancy.

In the physical design phase, SQL scripts were developed using SQL Server Management Studio (SSMS) to implement the final database. This included table creation with appropriate constraints (primary and foreign keys), default values, and SQL queries fulfilling the shop's transaction requirements. The final submission consisted of a .sql file of the database and a professional report outlining the full process from requirements gathering to normalization and implementation.