Coustmer ( C_Id, first name, C_last name, C_ address1 ,C_ address2, C_phonenumbe
ID: 3641404 • Letter: C
Question
Coustmer ( C_Id, first name, C_last name, C_ address1 ,C_ address2, C_phonenumber, C_email C_address,C_City,C_ State, C_zip,Country)
Room (Room_ID, R_Number, R_PriceID, R_Type_ID,Room Floor, Room Price,Room_Desc)
Room_Price ( Roomprice_ID, Currant room_Price)
Room_type (Room_Type_ID, Room_Type_Name, Room_Type_Desc)
Reservation (Reservation_Id, C_ID, Room_ID, Check_in_date, Check_out_date, Total Amount, Discount)
reserve Rooms ( Reservation_ID, C_ID, Room_ID)
Paymentmet (Pyment_ID , Payment_method, Room_ID, Reservation_ID, PaymentAmount, PaymentDate)
( I have Created the relational Schema design That keeps track of motel's bookings, rooms and Customers,Payments etc... ) I just need a little help that this design is a right design or i am doing something wrong) Thank you
Explanation / Answer
Hotel BookingsCustomer { CUST_ID, FNAME,LNAME,EMAIL,PHONE,FAX, STREET_ADDRESS, ALT_ADDRESS, ZIP}
"001", "David","Bruce","temp@p.com","(888) 345-234", "101 Lane", "201 Lane", "56666"
"003", "David","Ball","temp@p.com","(888) 345-234", "101 Lane", "201 Lane", "56666"
LOCATION { ZIP, CITY,STATE, COUNTRY }
"5666","miami","florida","USA"
Room { ROOM_NUMBER, FLOOR, DESC, STATUS }
"101","level 1", "scenic view, king size bed etc..", "Occupied/Available/Reserved"
Reservations { CUST_ID, ROOM_NUMBER, CHECKIN_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 }
Hotel Bookings
Customer { CUST_ID, FNAME,LNAME,EMAIL,PHONE,FAX, STREET_ADDRESS, ALT_ADDRESS, ZIP}
"001", "David","Bruce","temp@p.com","(888) 345-234", "101 Lane", "201 Lane", "56666"
"003", "David","Ball","temp@p.com","(888) 345-234", "101 Lane", "201 Lane", "56666"
LOCATION { ZIP, CITY,STATE, COUNTRY }
"5666","miami","florida","USA"
Room { ROOM_NUMBER, FLOOR, DESC, STATUS }
"101","level 1", "scenic view, king size bed etc..", "Occupied/Available/Reserved"
Reservations { CUST_ID, ROOM_NUMBER, CHECKIN_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 }