Answer both $($a$)$ and $($b$)$

$($a$)$ Define the following terms in the context of Relational Databases:

$($i$)$ Weak entity

$($ii$)$ What is a composite entity, and when is it used?

$($iii$)$ The three Phases of database Design

$($iv$)$ Cardinality

$($v$),1NF$

$($b$)$ The following tables form part of a database held in a relational DBMS:

Hotel $($hotelNo hotelName city$)$

Room

$($roomNo hotelNo type, price$)$

Booking

$($hoteINo guestNo dateFrom dateTo roomNo$)$

Guest

Where:

Hotel contains hotel details and hotelNo is the primary key.

Room contains room details for each hotel and $($roomNo$.$ hotelNo$)$ forms the primary key.

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

Guest contains guest details and guestNo is the primary key.

$($i$)$ Identify the foreign keys in this schema. Explain how the entity and referential integrity rules apply to these relations.

$($ii$)$ Produce some sample tables for these relations that observe the relational integrity rules. Suggest some general constraints that would be appropriate for this schema.