Question: Normalize up to the 3rd form: describe each step separately business rules: CUSTOMER ORDER Order# 001 Date: 01.01.98 Customer No. 12345 Salesperson No. 01 Salesperson
Normalize up to the 3rd form: describe each step separately business rules:
CUSTOMER ORDER Order# 001 Date: 01.01.98 Customer No. 12345 Salesperson No. 01 Salesperson Name: Fred Bloggs Name: NAWAZ Address: UOT Item No. Description Qty Price 0001 16mb SIMM 10 50.00 0004 32mb DIMM 2 100.00 Order Value 700.00
Step by Step Solution
★★★★★
3.46 Rating (143 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
To normalize this table up to the Third Normal Form 3NF follow these steps Step 1 First Normal Form 1NF Objective Remove repeating groups and ensure t... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help