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)