Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Identifv each of the following ne nory

Answered: 1 week ago

Question

Draft a proposal for a risk assessment exercise.

Answered: 1 week ago