Customer ( Cust_ID, Fname, Lname, Email, Phone, fax, Street_Adress, ALT_Address)

Question

Customer ( Cust_ID, Fname, Lname, Email, Phone, fax, Street_Adress, ALT_Address)
Location ( CUST_ID, CITY,STATE, COUNTRY )
Room ( Room_Number, Floor, DESC, Status)
Reservations ( Cust_ID, Room_Number, Checking_Date, Checkout_Date, FeedBack )
Pricing (Price_ID, Daily_Price, Discount_Percentage, Start_Date, End_Date )
Payments (Payment_ID, Cust_ID, Price_ID, Amount, Payment_Date)

( the relational schema keeps track of bookings,rooms and Customer. I am still confused about relationship of pricing,payments,room,reservation. I need to check the relational schema, and want to know the relationship between them..) Thank You :)

Explanation / Answer

I am not sure which part you are not getting..

Customer has (Reservations) One-Many (One customer can make Many reservations)

Customer has (Location) Many-One (Many customerr can live in One location by city,state,country)

Room has multiple Reservations One-Many ( Each room can be reserved at multiple dates)

Customer has Payments One-many ( customer can make multiple payments based on hotel pricing for rooms)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.