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

[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 20 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