Securing Higher Grades Costing Your Pocket? Book Your Assignment Help Tutor at The Lowest Price Now!

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

Assignment Help Features
Assignment Help Services
QR Code Assignment Help
elearningfeeds