Question

Convert the following ERD to Relational Data Model

В. Subtype discriminator is a composite attribute when there is an overlap rule PART Part No Description Location SUPPLIER Supplier ID Qty On Hand Part Type(Manufactured?, Purchased?) Part Type: Manufactured?="Y"' Purchased?="Y" MANUFACTURED PURCHASED SUPPLIES PART PART Unit Price Routing Number Copyright 2013 Pearson Education, publishing as Prentice Hall

Answer 1

Relational Data Model

PART(PartNo, Description, Location, QtyOnHand)

MANUFACTURED_PART(PartNo, RoutingNumber)

PURCHASED_PART(PartNo)

SUPPLIES(PartNo, SupplierID, UnitPrice)

SUPPLIER(SupplierID)

underlined are primary keys and italicised are foreign keys.

Do ask if any doubt. Please upvote.