Sample: ER Diagram for Booking Cabin Requirement

Question

ER Diagram for Booking Cabin Requirement

Answer

Sample output for er diagram

database schema for Booking Cabin Requirement

• Guest ( GuestID, Guest_Name, Guest_Address, Guest_Phone_Nbr )
• BookingCabinRequirement ( BookingID, GuestID, Discount_Percent, Final_Booking_Charge, Cabin_ID, Nbr_Required, First_Night, Last_Night, Charge_Rate, Guest_Phone_Nbr ) foreign key (GuestID) references Guest(GuestID)

foreign key (Cabin_ID) references Cabins(Cabin_ID )

• Cabins (Cabins_ID, Number, Floor, Room_Type)
• Payment( PaymentID, Total_Amount, PaymentMethod_ID)

foreign key (PaymentMethod_ID ) references PaymentMethod ( PaymentMethod_ID )

• PaymentMethod ( PaymentMethod_ID, Name)