Question: 1 0 . Create a Crow's Foot ERD to include the following business rules for a hotel reservation system: a . Each hotel has multiple
Create a Crow's Foot ERD to include the following business rules for a hotel reservation system:
a Each hotel has multiple rooms.
b Each room belongs to one hotel.
c Each guest can make multiple reservations.
d Each reservation is made by one guest.
e Each reservation is for one room.
f Each room can have multiple reservations.
g Each reservation is for a specific checkin date and checkout date.
h Each guest can provide multiple payment methods.
i Each payment method is associated with one guest.
j Each payment is linked to a reservation.
Please note that the entities and relationships in this question are specific to a hotel reservation system.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
