Indicate the type of normal form for each of the following relations. If the relation is not
Question:
Indicate the type of normal form for each of the following relations. If the relation is not in third normal form, decompose it into 3NF relations. Convert the 3NF relations into an E-R diagram.Refer to Figure 8-4 and answer the following questions:
Figure 8-4
a. OrderDetails(OrderID, ProductID, OrderedAmount)
b. Product(ProductID, ProductName, ProductPrice)
c. CustOrder(OrderID, OrderDate, CustomerID, CustomerName, CustomerAddress, CustomerPhone)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9781292351629
9th Global Edition
Authors: Joe Valacich, Joey George
Question Posted: