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)
ER Diagram Help | ER Diagram Assignment Help | Database Schema | ER Diagram Homework Help | ER Diagram Sample | Sample Homework
