Database modelling Assignment

Database modelling Assignment

Assignment Assumptions:

A storage can be in one or more cities. There can be storages that managers from the apartments own from various cities. The STORAGE location sits in its own entity and has a relating relationship to the LOCATION entity which stores the city name and has corresponding city name record. 2. A complex could have either a single or locked garage. There could be tenants where they could either have a single or locked garage or neither if possible. This is stored in a GARAGE entity and correlates to the complex entity since each complex will have both options. 3. a manager could be contacting either one or many different tradespersons. The manager of the company could possibly be contacting a tradesperson from various different companies to maintain the repairs and maintenance issues. The Tradesperson had its own entity and had no corresponding information about them however it corresponds to the MANAGER entity.

4. The tenant can have many maintenance problems in their apartment unit. Tenants could have more than just a few issues in their Apartment unit, this was stored in a M:N relationship entity which was called MAINTENECE_REPORT and was corresponding to the apartment entity.

5. A tenant can purchase one or more item from rental service. The tenant that lives in the Apartment could purchase more than one thing from the rental service which is provided for them. This was stored in an entity called RENTAL_SERVICE and had corresponding information regarding the service however the Tenant information will also be stored also.