The following tables form part of a database held in a relational DBMS:

Hotel $($hotelNo$,$ hotelName, city$)$

Room $($roomNo$,$ hotelNo, type, price$)$

Booking $($hotelNo$,$ guestNo dateFrom, dateTo, roomNo$)$

Guest $($guestNo$,$ guestName, guestAddress$)$

where

Hotel contains hotel details and hotelNo is the primary kev:

Room contains room details for each hotel and $($roomNo$,$ hotelNo$)$ forms the primary kev:

Booking contains details of bookings and $($hotelNo$,$ guestNo, dateFrom$)$ forms the primary kev:

Guest contains guest details and guestNo is the primary key.

Identify the foreign keys in this database schema $($mention both the referencing and referenced relation

for each$).[5$ points$]$

Answers: