Question: Draw an Enhanced ER model for a factory database. Make sure to include details like cardinality ratios, participation constraints, candidate keys, and subclasses indicating if

Draw an Enhanced ER model for a factory database. Make sure to include details like cardinality ratios, participation constraints, candidate keys, and subclasses indicating if they are overlap or disjoint.

  • Builders have a company name, unique license ID, and a rebate code.
  • Managers have a start date.
  • Managers have a unique ID.
  • People must be either a builder or a manager.
  • Objects have a unique code, description, and price.
  • People can purchase many objects and an object can be purchased by many people.
  • Objects must either be a factory part object or a building. However, they cannot be both.
  • Factory part objects have a barcode to look up. Buildings have a blueprint and whether they need changes.
  • Buildings can also be houses. Houses have the style of the house. Buildings must be sold by at least one realtor.
  • Realtors has a unique name and an address. A realtor can sell many different houses.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!