Securing Higher Grades Costing Your Pocket? Book Your Course help Tutor at The Lowest Price Now!

Get Instant Course Help

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

Course Help Features
Course Help Services
QR Code Course Help
elearningfeeds