Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago