Guest

guestIDfirstNamelastNameemailAddressphoneNumber
1JohnDoejohn.doe@example.com1234567890
2JaneSmithjane.smith@example.com0987654321

Room

roomIDapartmentTypenumberOfGuests
(→ Apartment.type)
1High-end Residential2
2Standard4

Booking

bookingIDstartDateendDateguestIDroomID
(→ Guest.guestID)(→ Room.roomID)
12022-01-012022-01-0711
22022-01-082022-01-1422

Apartment

aptIDtypeaddresscapacity
1High-end Residential123 Main St10
2Standard456 Elm St8

Commercial_Appliance

applianceIDnamestatusapartmentID
(→ Apartment.aptID)
1Espresso MachineOperational1
2Espresso MachineNeeds Repair2
3BlenderOperational1
4BlenderNeeds Repair2

Inventory

inventoryItemquantityreorderLevel
Soap500200
Shampoo300100