Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started