Create a Relational model for the building maintenance system described

Your Relational model is to include the following elements:

-All relations/classes

-Associations between classes with labels

-Multiplicity (UML) between classes. For 3 different cases of multiplicity provide a statement of meaning.

-Attributes for each relation, with visibility and attribute type (allowed by Access)

-Primary and foreign keys indicated by (pk) and (fk)

-Any inheritance, composition, many -to -many associations

- Assumptions

-Roles, methods, responsibilities are not required

Requirements: Building Maintenance system

A rental property management company wants to develop a Building Maintenance System. This system will be used by the company to manage maintenance requests from tenants in the several rental buildings that it manages in the city. Each building has a maintenance manager. This maintenance manager is responsible for creating accounts in the system for each tenant in their building. One tenant can rent multiple apartments within the same or different buildings. Tenants can submit maintenance requests using this system. Each maintenance request will have a request ID, category, and description. Maintenance managers manage a maintenance crew in their buildings. Maintenance crew members in the building can log into the system to check the maintenance issues raised by the tenants. After the crew fixes these issues in the apartment, they can log into the system and update the states of the maintenance request to closed. Tenants can access the status of maintenance requests only for the apartment(s) they are renting.