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
Do You Want A Fresh Assignment Like This Order Now

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