Question 1. The ER model, provided below, contains errors and is incomplete. You need to identify the errors/omissions, rectify them, and then redraw the diagram,
Publish By:
Admin,
Last Updated:
01-May-24
Price:
$120
Question 1 5 Marks
The ER model, provided below, contains errors and is incomplete.
You need to identify the errors/omissions, rectify them, and then redraw the diagram, so that the redrawn ER model illustrates the entities and relationships for a Strata unit model with the following requirements:
- a building can have many strata units
- each building must have its address recorded
- a strata unit is situated in one building only
- an owner can own many strata units
- an owner can have many contact numbers
- a strata unit can be owned by many owners
- each owner’s percentage owning of the strata unit must be recorded
- building, owner and strata unit are identified by their respective ids
Note: If you have any additional assumptions, mention them along with your redrawn diagram.