Question $4-(15$ marks$)$

Convert the given scenario into ONF, $1$NF$,2$NF$,3$NF$.$ Show all normal forms with data in table

format. Identify the primary key and foreign keys of tables at each normal form. Give appropriate

table names and the primary key and foreign key $($s$)$ of each table at the end of the third normal form.

Radissen Blue Hotels

Booking Id: $89776$

Guest Passport Number: T$98777$

Guest Name: Sulaiman Al Habsi

Guest Address: Way No$\mathrm{.}899,$ Ruwi

Booking Date: $10/20/2023$

Guest Country Code: OM

Guest Country Name: Oman

Booking Start Date: $11/18/2023$

Booking End Date: $11/20/2023$