Conceptual Database Model of Joanne Myers Apartments

COVER PAGE

Contents
1 Discussion.................................................................................................................................................3
2 Business rules...........................................................................................................................................3
3 Entity relationship diagram......................................................................................................................6
4 Summary..................................................................................................................................................6

1 Discussion
The solution provided in this report is conceptual database model of the Joanne Myers Apartments
database and the steps that have been followed in order to arrive at the final design. The first step is to
identify the business rules y thoroughly analyzing the case study provided in the document. From the
business rules an entity relationship is drawn using Microsoft Visio to show the entities and their
attributes and all the different types of relationships that exist between the entities. A discussion of the
justification and any assumptions made is presented on the last section.
While modelling the database no problem was experienced as my analysis of the case study provided all
the information I needed to complete the task
2 Business rules
Based on the case study, the following are the business rules derived;
Entity: BUILDING
A BULIDING has one or more APARTMENT
A BUILDING is managed by one LESSEE.
Entity: LEASE
A LEASE can be signed by one or more LESSEE
A LEASE is for one APARTMENT
Entity: APARTMENT
An APARTMENT belongs to only one COMPLEX
An APARTMENT has one and only one LEASE at a time
An APARTMENT is assigned to one or more PARTKING_LOT
An APARTMENT can have one or more MAINTENANCE_JOB
AN APARTMENT has one or more PREINSTALLED_EQUIPMENT
Entity: KEY
A KEY results to one or more KEY_ALLOCATION records
Entity: PARKING_LOT
A PARKING_LOT is associated with one and only one APARTMENT
A PARKING_LOT belongs to only one building COMPLEX.
Entity: LOCKUP_GARAGE