Database Technology Repeat CA | ERD Entity Relationship Diagram, Normalization and SQL
Database Technology Repeat CA ERD (Entity Relationship Diagram) i. Identify each of the entities ii. Identify2-3 attributes for each entity with a key attribute iii. Name the relationships for each of the binary pairs iv. Identify the degree of relationship for each of the binary pairs v. Decompose any many to many relationships vi. Draw the completed Entity Relationship Model A restaurant manager wishes to set up a database to record the details of its customers, reservations for tables in the restaurant and the employees assigned to tables. Screenshot For each customer the database will record -- a customer number (unique), name, address and phone number. The details to be recorded for each table include - table number (unique), capacity. Customers make reservations for tables. The requested time and date of the reservation is recorded along with a unique reservation number. Each reservation is made by one customer and books one table. A customer will make a number of rese...