DATABASE MODELLING.

DATABASE
MODELLING

Overview of database model
• The main purpose of developing the model is to facilitate user with
effective understanding
• This analyzes the activities that is taking place within the case study.
• The major attributes that are developed for this case study are as
follows:
• BUILDING
• APARTMENT
• PREINSTALLED_EQUIPTMENT
• PARKING_LOT
• LEASE
• LESSEE

Overview of database model
• MAINTENANCE_COMPANY
• MAINTENANCE_JOB
• KEY
• RENTAL_EQUIPTMENT
• RENTAL
• RENTALPAYMENT
• LOCKUP_GARAGE

Reason
• The main aim behind developing this database model
is to facilitate the users.
• The main reason behind having BUILDING attribute
is that it will help in managing each building ID along
with address.
• For this attribute buildingID is primary key as this is
the main and unique attribute.
• Similarly for each attribute it is being prepared

Reason
• Each attribute contains a primary key and a foreign
key
• The main purpose behind having a foreign key in
each table is that it helps in connecting with other
tables.
• Key_allocations is the only table that contains two
entities that are the main primary keys and also acts
as foreign key.

Scope of the Database
design
• The scope of the developed database design is that it
helps in analyzing the case study.
• This helps in getting all the entities listed along with
their attributes
• Moreover the database design also offers
normalization up to 3NF.

Scope of the Database
design
• The database design also helps in developing a
relational model along
• Lastly with the use of relational model an ERD
is developed

Limitation
• After analyzing the database model I can state that the
manager id that is being described in the BUILDING
attribute has no other link.
• This is the only table that contains this entity.
• Thus it can hamper the working of the whole
database model.

Reference
• Al-Masree, H.K., 2015. Extracting Entity Relationship Diagram (ERD) from
relational database schema. International Journal of Database Theory and
Application, 8(3), pp.15-26.
• Connolly, T. and Begg, C., 2015. Database Systems. Pearson Education UK.
• Dennis, A. and Wixom, B.H., 2018. Systems analysis and design. Wiley.