Database Implementation Report for CQUnited Property Management System

COIT202
47
Database
Design
and
Develop
ment (T2
2019)
September 25
20
19
Student ID:
Student Name:
Module Tutor:
Assessme
nt Item 2
–
Assignme
nt 2

Implementation Report
Introduction
The database implementation of CQUnited Property Management system (CQUPM)
is being shown in the report. The report is showing the full concept of database
normalization, functional dependency etc.
The CQUPM database is implemented into the MS Access. The MS Access is very
useful and attractive relational database management system.
Normalization
ER Diagram Mapping
customer (customerID, customerName, address, phone)
staff (staffID, staffName, address, phone, staffType)
manager (managerID, qualification)
Foreign Key (managerID) References staff (staffID)
e_empl_category (categoryID, categoryName, hourlyRate)
external_employee (e_employeeID, tradeLicenseNo, categoryID)
Foreign Key (e_employeeID) References staff (staffID)
Foreign Key (categoryID) References category (categoryID)
owner (ownerID, ownerName, address, phone)
supervisor (supervisorID, managerID)
Foreign Key (supervisorID) References manager (managerID)
Foreign Key (managerID) References manager (managerID)
property (propertyID, propertyType, address, listedWeeklyRental, numBedRoom,
numBath, availableDate, managerID, ownerID)
Foreign Key (managerID) References manager (managerID)
Foreign Key (ownerID) References owner (ownerID)
2 | P a g e

rental (rentalID, contractStartDate, contractEndDate, weeklyRental, customerID,
propertyID)
Foreign Key (customerID) References customer (customerID)
Foreign Key (propertyID) References property (propertyID)
application (applicationID, reference, submittedDate, processedDate, comments,
customerID, propertyID)
Foreign Key (customerID) References customer (customerID)
Foreign Key (propertyID) References property (propertyID)
repair_job (jobID, jobDescription, completedDate, charge, e_employeeID,
propertyID)
Foreign Key (e_employeeID) References external_employee (e_employeeID)
Foreign Key (propertyID) References property (propertyID)
Functional Dependency in Tables
Customer
customer (customerID, customerName, address, phone)
customerName  customerID
address  customerID
phone  customerID
Staff
staff (staffID, staffName, address, phone, staffType)
staffName  staffID
address  staffID
phone  staffID
staffType  staffed
3 | P a g e