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,

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.

Expert's Answer

Hire Expert Tutors

Get Professional Tutoring at Low Price in Australia


Academic Excellence
Professional
Tutoring Services
👥

25k+

Sessions Done

⭐

4.9/5

Student Rating

👨‍🏫

600+

Expert Tutors

Why Learn With Us?

🧠

Concept Clarity

🎯

Personalized Plan

💸

Affordable Rates

📅

Flexible Schedule

📈

Results Driven

💬

24/7 Support

You may also like

TOP