Question: For table 2 : ORDER _ LINE ( order# , product# , description, quantity, unit price ) 2 2 a . List all functional dependencies
For table : ORDERLINE order# product# description, quantity, unit price
a List all functional dependencies
b What is the key? Note to analyze or normalize a table, you MUST figure out the key of the table first
c What Normal Form is this table in Why? Use the definition of the normal form that applies
d Describe a specific modification anomaly that may occur in ORDERLINE table.
e Normalize the table into a set of tables that are at least NF
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
