CQUnited Property Management Database: ER Diagram and Logical Design

This assignment presents an Entity-Relationship (ER) diagram and a logical schema (3NF relations) for the CQUnited Property Management database system. The solution begins with outlining business rules and assumptions, including details on properties, owners, applications, customers, bookings, payments, and staff. The ER diagram visually represents these entities and their relationships. The logical schema then translates the conceptual model into 3NF relations, detailing tables for owners, properties, applications, customers, bookings, payments, staff, external staff, supervisors, services, and property managers. This structured approach ensures efficient data storage and retrieval for managing rental properties and related services. The assignment concludes with a bibliography citing relevant database systems resources.

Running head: ER DIAGRAM
ER Diagram
Name of the Student:
Name of the University:
Author note

1
ER DIAGRAM
ER Diagram
Business Rules and Assumptions
The business rules and assumptions which were used for the development of the ERD
are:
 The details of the properties are stored in the system. The property details include the
number of rooms in the property and the picture of the property. In addition to this,
properties are identified with help of the unique PropertyID.
 The details of the property owners are also stored in the system and the owners are
identified with the OwnerID.

2
ER DIAGRAM
 The details of the application made for the property and the owners are also stored in the
system.
 In addition to this, the details of the customers have been stored in the system and the
booking details for the customers are stored in the system. In addition to this, the details
of the booking are also stored in the system. Each of the bookings are identified with the
help of the BookingID.
 The payment details for each of the booking are stored in the system and are identified
with the help of the PaymentID. The details of the customers and the payment procedures
are stored in the system.
 The staffs of the organization have their details stored in the system are identified by their
staffID. The staffs have been further specialized into the supervisors, property managers
and the external staffs. The supervisors are the ones that would be supervising the
property managers. The property managers are identified by their managerID and are
their supervisors are identified by the SupervisorID. In addition to this, there are external
staffs who are identified by the ExtStaffID. The external staffs have the details such as
the staff name and the type of staff.
 There are three type of external such as electrician, plumber or handyman however they
have been classified under the ExtStaffType attribute.
 The staffs perform the services on the properties the details of which are stored in the
database and the service details are accessed with the help of their unique ServiceID
which provides the details of the property in the system and the date on which the
services are being performed.

3
ER DIAGRAM
Logical Schema (3NF Relations)
Owners (OwnerID (pk), OwnerName, OwnerAddress, OwnerContact)
Property (PropertyID (pk), OwnerID (fk), PropertyPicture, PropertyName, PropertyType,
PropertyAddress, NumberOFBedroom, NoOfBathroom, WeeklyRental)
Application (ApplicationID (pk), PropertyID (fk), OwnerID (fk))
Customers (CustomerID (pk), CustomerName, CustomerAddress, CustomerContact)
Booking (BookingID (pk), BookingDate, CustomerID(fk), PropertyID (fk), PaymentID (fk))
Payment (PaymentID (pk), BookingID (fk), PaymentAmount, PaymentDate)
Staff (StaffID (pk), StaffName, StaffType, StaffAddress, StaffContact)
External Staff (ExtStaffID (pk), StaffID (fk), ExtStaffName, ExtStaffType)
Supervisors (SupervisorID (pk), SupervisorName, StaffID (fk))
Services (ServiceID (pk), PropertyID (pk), Description, ServiceType, StaffID (fk))
Property Manager (PropertyManagerID (pk), SupervisorID (fk), StaffID (pk), PropertyID (fk),
ManagerName, ManagerContact, ManagerAddress)

4
ER DIAGRAM
Bibliography
Connolly, T. and Begg, C., 2015. Database systems. Pearson Education UK.
Hilles, M.M. and Naser, S.S.A., 2017. Knowledge-based Intelligent Tutoring System for
Teaching Mongo Database.
Stonebraker, M., Deng, D. and Brodie, M.L., 2017. Application-database co-evolution: A new
design and development paradigm. New England Database Day, pp.1-3.