RELATIONAL DATABASE
GROUP PROJECT

This group project was the final for my Database Development class. The assignment was to design and implement a MySQL Relational Database from the ground up.

We were provided with a Case Study for a fictional Property Management Company, "DreamHome". This document provided an explanation of the core functions of the business. A mock interview conducted with the different levels of staff at DreamHome was also included along with sample data, reports, and forms. This provided us with examples of what needs this database had to fulfil. Finally, the requirements for the new database were provided.

The result of our work was a database built in SQLyog with enough data input to run our queries. The final design document we submitted included:

1. Homogenous sentences
2. ER Diagram(s)
3. Relational Schema
4. Join Paths
5. Normalization
6. Database table Schema after implementation
7. SQL statements and result sets that answered the following questions:
   • Show all records for each table.
   • Show all properties that are currently rented listing renters name, property address.
   • Show all properties that are not currently rented listing property number, managing staff name and branch, owner name.
   • Show all clients who are not currently renting and include phone number and address.
   • Show all property grouped by branch and include total monthly rent being received by branch.
   • Show all property grouped by owner and include current total monthly income to that owner.
   • Show all staff that have an Assistant position and the branch they work at.
   • Show all staff that make 24,000 or more, the branch they work at, their position.
   • Show total salary for each position by branch and total for all branches.

This assignment was challenging, but rewarding. I was able to walk away from this class knowing that I have a solid grasp of the fundamentals behind Database Development.