Question

Create the following tables as part of a Hotel Business database:

1. Hotel (hotelNo, hotelName, city) where Hotel contains hotel details and hotelNo is the primary key
2. Room (roomNo, hotelNo, type, price) Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key
3. Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Booking contains details of bookings and (hotelNo, guestNo, dateFrom) forms the primary key
4. Guest (guestNo, guestName, guestAddress) Guest contains guest details and guestNo is the primary key.

**Please help creating the relationships and diagram of a database created as described above**

-A diagram of your tables showing appropriate relationships

Answer 1

ER diagram

roomNo hotelNo hotelName city type hotel room price book guest fromDate toDate guestNo guestName uestAddress

Table view of relations

Hotel Room Guest hotelNo roomNo ぐ uestNo hotelName hotelNo type price guestName city guestaddress Booking hotelNo roomNo dateFrom dateTo guestNo

Here

hotelNo in room is foreign key of hotelNo in hotel

hotelNo in booking is foreign key of hotelNo in hotel

roomNo in booking is foreign key of roomNo in room

guestNo in booking is foreign key of guestNo in guest

Primary keys are underlined.