Data Fields and Tables for the Apartment Management Database System
I'm trying to get some ideas for my relational database.
List all of the data fields and tables that would be needed for the Apartment management database system described in the attached document. You can just simply list them in a Word doc.
Attachment Content Summary (Note: view attachment at the above link before purchasing. Actual attachment content may vary slightly from that shown below.)
Phoenix Rising Apartment Requirements.doc
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, …
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.
d
j
†
Љ
љ
¶
Д
Ж
И
И
l
И
Р
j
l
n
~
И
Ъ
y 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.
Flat-file database - What are some of the key differences between a flat file and a relational database?
Which of the two storage methods do you think is most useful in a real-world application?
Which one is more feasable? - As we start designing a database for implementation should we use the latest and greatest technology? Does the user need a flat-file or object-oriented database? Give an example of each and how it wo ...