magement System Time Allowed: $2$ hrs

Room

$($hotelNo$,$ hotel a database held in a relational DBMS; Hotel

Booking

Guest $($roomNo$,$ hotelName, city$)$

$($hotelNo$,$ hotelNo, type, price$)$

$($guestNo$,$ guestNo, date From, date To$,$ room No$)$

Where:

Hotel contains hotel details and hotel No is the primary key;

Room contains room details for each hotel and $($room No$,$ hotelNo$)$ forms the primary key;

Booking contains details of bookings and $($hotelNo$,$ guestNo, date From$)$ forms the primary key; Guest contains guest details and guestNo is the primary key.

a$.$ Identify the foreign keys in this schema. Explain how the entity and referential integrity rules apply to these

b$.$ Produce some sample tables for these relations that observe the relational integrity rules.

c$.$ Suggest some general constraints that would be appropriate for these schemas.

$2.$ a$.$ What is a relation? Hence what are the properties of relations?

b$.$ Identify what normal form relations revolves around and identify what dependency structures are based on$.$

c$.$ Consider the following relation INVOICE

INVOICE

$\backslash$table$[[$Amah$,$Sapele,$\backslash$table$[[$Invoice$-$No$],[$Inv$-200]],$Invoice$-$Type,Service,$],[$Baby$,$Sapele,$\backslash$table$[[\backslash$table$[[$Inv$-200],[Inv-450$