Database Management System Project: SFV Case Study and ER Diagrams

This project is a comprehensive analysis of a database management system for the Smart Food Venture (SFV) case study. The project begins by identifying key tables such as customer_details, manager_details, item_details, order_details, and discount_details. It then details the attributes within each table. Normalization is addressed, with figures illustrating the 1st and 2nd normal forms. The assignment outlines primary and foreign keys and provides SQL statements for creating each table, including the definition of data types and constraints. An Entity-Relationship (ER) diagram is constructed, showcasing the relationships between the tables. The project also includes SQL INSERT statements for populating the tables with sample data and demonstrates various SQL queries, including SELECT, DROP TABLE, UPDATE, and DELETE statements. Finally, a bibliography of relevant database management sources is included.