Sample: ER Diagram for Booking Cabin Requirement

Question

ER Diagram for Booking Cabin Requirement

Answer

Sample output for er diagram

ER Diagram for Booking Cabin Requirement Assignment Help Order Now ER diagram for booking cabin requirement

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