Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the following table recording products ordered by film production customers (Table 2) and the description of each attribute. Attributes: OID = Order ID, O_Date
Given the following table recording products ordered by film production customers (Table 2) and the description of each attribute. Attributes: OID = Order ID, O_Date = Order Date, CID = Customer ID, C_Name = Customer Name, C_State =C ustomer State, PID= Product ID, P_Desc c= Product Name, P_Price = Product Price, Qty = Quantity Purchased (a) Identify the normal form of Table 2. Explain why you have selected this normal form based on the data characteristics observed in Table 2. (2/100) (b) Identify all functional dependencies. (3/100) (c) Perform normalization on the table up till 3 NF. Show every step of the normalization process and present in final tables in the form of relational schemas. Give each table finalized in 3NF an appropriate name. Underline the primary keys and put an asterisk () at the end of a foreign key. (20/100)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started