Realize the logical model of this situation with an Entity-Relationship diagram. You must identify the necessary entities, relationships, cardinalities, identifiers, and attributes. Specify, if applicable, any assumptions necessary to understand your model
You have been assign to design a
When a tenant is accepted, a lease is signed (only one tenant can sign the lease), which determines the amount of the monthly rent, as well as the start and end date of the tenancy.
When advertising the apartments, the rent requested is also indicated. The tenants choose an apartment according to the number of rooms and according to the services included, which can be the same from one apartment to another.
In order to satisfy the banker, the value of the buildings and their year of construction are preserved, making it possible to compare the rents demanded with the value of the building in order to obtain profitability.
Realize the logical model of this situation with an Entity-Relationship diagram. You must identify the necessary entities, relationships, cardinalities, identifiers, and attributes. Specify, if applicable, any assumptions necessary to understand your model
Step by step
Solved in 5 steps with 1 images
