Ask a question from expert

Ask now

Assignment On Database Management

6 Pages518 Words312 Views
   

Added on  2020-04-01

Assignment On Database Management

   Added on 2020-04-01

BookmarkShareRelated Documents
Database Management 1Database ManagementStudent’s NameCourse NameLecturerUniversityDate
Assignment On Database Management_1
Database Management 2Table of ContentsEntityrelationdiagram.............................................................................................................................................................................3Relationaldatastructures.........................................................................................................................................................................3Relationaldatabaseschema......................................................................................................................................................................4
Assignment On Database Management_2
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)
Assignment On Database Management_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Enterprise Rules - Hospital Management System
|22
|1437
|45

Database Management System Assignment 2022
|32
|6949
|24

Data Management: The Queensland College database
|8
|1018
|333

H16W 35 Relational Database Management Systems
|16
|1641
|138

ITECH 1006 - Database Management Systems FUA
|7
|741
|205

Advanced Management Console
|35
|7601
|31