Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider a real - estate company, which manages rental properties. Each property has an address, several bedrooms, bathrooms, and car spaces. A rental property may
Consider a realestate company, which manages rental properties. Each property has an address, several bedrooms, bathrooms, and car spaces. A rental property may have several rental agreements. A rental agreement details the weekly rent that is agreed upon with one or more tenants for a property for a given period. For each of these tenants, the details that need to be recorded include first name, last name, and date of birth. At any point in time, each staff member must be responsible for managing at least one property, where a property can be managed by multiple staff members and must be managed by at least one staff member at any point in time. Staff members also have a first name, last name, and date of birth. At any point in time a property is owned by one or more landlords. The ownership of each property may also change over time.
The ER diagram shown below is one attempt at modelling this domain. Consider what errors you can identify in this model.
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