Question: For table 2 : ORDER _ LINE ( order# , product# , description, quantity, unit price ) 2 2 a . List all functional dependencies

For table 2: ORDER_LINE (order#, product#, description, quantity, unit price)
22a. List all functional dependencies
22b. What is the key? (Note, to analyze or normalize a table, you MUST figure out the key of the table first)
22c. What Normal Form is this table in? Why? Use the definition of the normal form that applies
22d. Describe a specific modification anomaly that may occur in ORDER_LINE table.
22e. Normalize the table into a set of tables that are at least 3NF.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!