Sample: ER Diagram for Booking Cabin Requirement

Question

ER Diagram for Booking Cabin Requirement

Answer

Sample output for er diagram

ER Diagaram Assignment Help Order Now

ER diagram 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 Diagaram Help | ER Diagaram Assignment Help | ER Diagaram Homework Help | ER Diagaram Sample