Database Design for CQUnited Property Management - COIT20247 T2 2019

This document presents a solution for COIT20247 Assignment 1, focusing on the database design for CQUnited Property Management (CQUPM). The assignment requires the development of a relational database to manage rental properties, customers, staff, and rental activities. The solution includes an Entity Relationship (ER) diagram to visually represent the database schema, detailing entities such as Property, Customer, Employees, Maintenance, Rents, and Property_Management, along with their attributes and relationships. Assumptions and business rules are outlined to guide the database design, ensuring data integrity and efficient query processing. The logical design is provided, defining table structures, primary keys, foreign keys, and data types for each entity. The document also includes a bibliography of relevant database management resources. The goal of this assignment is to design a database conceptual schema that efficiently records and tracks all listed properties, customers, staff, and relevant rental activities for CQUPM.

Running head: COIT20247 T2 2019
Assessment item 1—Assignment 1
Name of the Student
Name of the University
Author’s Note

1
COIT20247 T2 2019
1. Entity Relationship Diagram
2. Assumptions and Business Rules
The database for CQUnited Property Management (CQUPM) is developed based on the
following assumptions:
 There may be one or more property of the customer required by the customer and they
would have necessary documents needed for booking
 An employee is assigned for a property for managing the real estate from property owner.

2
COIT20247 T2 2019
 The DBA would manage customer and employee details for handling errors in the
database
 The maintenance jobs are needed to be done by the external employees and they are
needed to be recorded in the database.
The business rules identified for the development of the logical design of the database are given
below:
 The list of property, customer and employees are needed to be maintained in the database
for managing rental property and services.
 The details of the property is needed to be recorded including type, address, rooms,
bathrooms, photo weekly rental and availability.
 The application of the customer is needed to be stored and the tables should be connected
using foreign key for returning appropriate result for any query made by the user.
3. Logical Design
The database schema for the entity relationship diagram is as follows:
Property (Property_ID [PK], Customer_ID [FK], Property_Type, Owner_Details,
Address, Bathroom, Bedroom, Weekly_Rentals, Photos, Available_Date)
Maintenance (Maintenance_ID [PK], Property_ID[FK], Employee_ID,
Maintenance_Date)
Employees (Emp_ID [PK], Emp_Name, Phone, Position, Annual_Salary,
Working_Location)
Customer (Customer_ID [PK], Customer_Name, Street, Suburb, State, Postcode, Email)

3
COIT20247 T2 2019
Rents (Booking_ID [PK], Property_ID [FK], Customer_ID [FK], Manager_ID [FK],
Date_Booked)
Property_Management (Management_ID [PK], Emp_ID [FK], Property_ID [FK], Name,
Email, Contact, Salary)

4
COIT20247 T2 2019
Bibliography
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
Hoffer, J., Venkataraman, R. and Topi, H., 2015. Modern database management. Prentice Hall
Press.
Mitrovic, A. and Suraweera, P., 2016. Teaching database design with constraint-based
tutors. International Journal of Artificial Intelligence in Education, 26(1), pp.448-456.
Mohankumar, M. and Kumar, M.A., 2016. Green Database Design Model in Software
Development Life Cycle Phase. Indian Journal of Science and Technology, 9(30).
Raley, R.E. and Bray, M.H., 2017. Material Design Database Development for Thermal
Insulation.
Shad, M.S. and Fallahi, K., 2015. Studying the Relationship of Identity-Genuineness and Desired
Organizational Image on Insurance Companies Performance (Case Study: Iran
Insurance). Environment Conservation Journal, 16(Special Edition), pp.371-378.
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.
Williams, T.N., Kuenemann, M.A., Van Den Driessche, G.A., Williams, A.J., Fourches, D. and
Freeman, H.S., 2018. Toward the rational design of sustainable hair dyes using cheminformatics
approaches: step 1. database development and analysis. ACS Sustainable Chemistry &
Engineering, 6(2), pp.2344-2352.