Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions