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
Get step-by-step solutions from verified subject matter experts
