Data Fields and Tables: The Apartment Management Database System
Not what you're looking for?
Design of a relational database system for the Phoenix Rising Apartment rental company.
The apartment rental business is made up of three different buildings. Building One and Two have three floors each, with 5 apartments on each floor. Building Three has five floors, with 5 apartments each.
The company has a total of six employees: A manager, two rental agents and three maintenance workers.
The manager has a list of suppliers for purchasing products such as furniture, computers, office supplies, building hardware...etc
The following is a list of tasks that the company expects out of the new database:
• Keep track of agents and the leases they sign. The agents do not share leases.
• Keep track of renters (Note: Renters have their address and phone numbers on file).
• Keep track of the apartments and buildings.
• Keep track of maintenance orders. Several maintenance workers can work on the same job.
• Keep track of furniture and hardware suppliers, who are managed by the business manager.
• Keep track of products bought, which are mainly handled by the manager.
Note: Products from a certain category can be bought from more than one supplier. In other words, it is possible for them to purchase 2 computers from 2 different places.
Purchase this Solution
Solution Summary
This solution provides guidelines on how to design a relational database system for the Phoenix Rising Apartment rental company.
Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions
This quiz consists of some basic networking questions.
C# variables and classes
This quiz contains questions about C# classes and variables.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.