Limited Time OfferFLAT 20% off & $20 bonus sign up. Order Now
New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now
When designing the database the manager has asked that you consider questions that may be asked of the database:
Assumptions made include:
Guests(guestID, title, fname, lname, address, email, mobile_number, home_number, work_number, drivers_license_no, passport_no, date_entered, loyalty_card_no)
Staff(staffID,fname,lname,address,phone,employment_type, TFN, login_name, password)
Supervisor(supervisorID,staffID)
Rooms(roomNo,room_rate,status, typeID)
Bookings(bookingNo,booking_date,logged_time, checkin_date, checkin_time,checkout_date,checkout_time,cancellation_date,room_guarantee,no_of_occupants,duration, guestID,roomNo)
Payments(paymentNo,amount,payment_date, bookingID, methodID)
RoomTypes(typeID, name, description)
RoomPrices(rpriceID,price, typeID)
RoomFacilities(rfacilityID,facilityID,typeID)
FacilitiesList(facilityID,name)
ServiceCharges(chargeID,unit_price,GST,service)
BookingCharges(bchargeID,bookingID,chargeID)
PaymentMethods(methodID,name)
GuestNotes(NoteID,entry_date,entry_time,details,followup_date,completed_date,guestID,staffID)
Field | Type | Number |
title | Varchar | 7 |
fname | Varchar | 10 |
lname | Varchar | 20 |
address | Varchar | 50 |
| Varchar | 50 |
Fname | Varchar | 10 |
Lname | Varchar | 20 |
Address | Varchar | 50 |
Employment_type | Varchar | 20 |
Login_name | Varchar | 20 |
password | Varchar | 20 |
No matter how close the deadline is, you will find quick solutions for your urgent assignments.
All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.
Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.
We offer academic help services for a wide array of subjects.
We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.
15,000+ happy customers and counting!