Page 1 of 1
Question 3 [ULOS 1, 2, 3, 4) 6 Marks The following tables form part of a database held in a relational DBMS: a. Hotel (h
Posted: Tue Jul 05, 2022 10:26 am
by answerhappygod
- Question 3 Ulos 1 2 3 4 6 Marks The Following Tables Form Part Of A Database Held In A Relational Dbms A Hotel H 1 (25.83 KiB) Viewed 21 times
Question 3 [ULOS 1, 2, 3, 4) 6 Marks The following tables form part of a database held in a relational DBMS: a. Hotel (hotelNo, hotelName, city) b. Room (roomNo, hotelNo, type, price) c. Booking (hotelNo, guest No, dateFrom, dateTo, roomNo) d. Guest (guestNo, guestName, guestAddress) Analyse this schema and then answer the following three requirements: Requirement 1: Identify a primary key in each table. [ULOS 1, 2, 3, 4] 2 Marks Requirement 2: Identify the foreign keys in the schema. Explain how the entity and referential integrity rules apply to these relations. [ULOS 1, 2, 3, 4] 2 Marks