Data Fields and Tables for the Apartment Management Database System

 

 

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.