Database Management 2Table of ContentsEntityrelationdiagram.............................................................................................................................................................................3Relationaldatastructures.........................................................................................................................................................................3Relationaldatabaseschema......................................................................................................................................................................4
Database Management 3EntityrelationdiagramGuestsStaffSupervisorRoomsBookingPaymentsRoom TypeRoom PriceRoom FacilitiesFacilities ListService ChargesPayment MethodsBooking ChargesGuest NotesguestIDPKtitlefnamelnameaddressemailmobile_numberhome_numberwork_numberdrivers_license_nopassport_nodate_enteredloyalty_card_nostaffIDPKfnamelnameaddressphoneemployment_typeTFNlogin_namepasswordsupervisorIDPKstaffIDFKroomNo PKtypeIDFKroom_ratestatusbookingIDPKguestIDFKroomNobooking_datelogged_timecheckin_datecheckin_timecheckout_datecheckout_timecancellation_dateroom_guaranteeattribute nameattribute nameoccupantsdurationpaymentNoPKbookingIDFKamountpayment_datemethodIDFKtypeIDPKnamedescriptionrpriceIDPKtypeIDFKpricerfacilityIDPKfacilityIDFKtypeIDFKfacilityIDPKnameChargeIDPKunit_priceGSTservicemethodIDPKnamebchargeIDPKbookingIDFKchargeIDFKnoteIDPKguestIDFKentry_dateentry_timedetailsstaffIDfollowup_datecompleted_dateAssumptionsAssumptions made include: The tables roomtype an roomprice have a one-to-one relationship as each room type has only one price. The tables roomtype and roomfacilities have a one-to-many relationship as one type of room may have many facilities. RelationaldatastructuresGuests(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)
End of preview
Want to access all the pages? Upload your documents or become a member.