The table below contains sample data for products, vendors who supply the products, and managers who manage
Fantastic news! We've Found the answer you've been seeking!
Question:
The table below contains sample data for products, vendors who supply the products, and managers who manage the vendors. {VendorID, ProductID} is the composite primary key for this single table database, as indicated by the underlined column names. For this database,
a. Give specific examples of insertion, deletion, and modification anomalies, based on the data.
b. Normalize the database to 3NF.
Related Book For
Operations Management Processes And Supply Chains
ISBN: 9781292409863
13th Global Edition
Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman
Posted Date: