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.