Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started