Database Project: ERD, RDM, Functional Dependencies, and Cardinalities

This database assignment solution presents a comprehensive analysis of restaurant menu data, encompassing both individual and group contributions. The assignment begins with the identification of entities, attributes, functional dependencies, relationships, and cardinalities within the provided restaurant menu context. The solution highlights the identification of key entities such as Item, Promotion, Restaurant, and Branch, along with their respective attributes. Functional dependencies are established using primary keys like ItemID, PromoCode, and RestaurantID. The solution then delves into the creation of an Entity-Relationship Diagram (ERD) and a Relational Data Model (RDM), incorporating elements from both individual and group work. The RDM includes tables for Customer, Order, Item, Restaurant, Promotion, Delivery, Branch, and Payment, with the specification of primary and foreign keys to ensure data integrity and efficient database design. The assignment provides a practical application of database design principles, including entity identification, attribute definition, relationship modeling, and the creation of a relational data model.