Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the following un-normalized data and prepare a set of tabled that is in its third normal form. Given below is the design of a
Use the following un-normalized data and prepare a set of tabled that is in its third normal form.
Given below is the design of a Sales table for a wholesale company. Normalize it and label the primary key for each of your tables.
SO# | Date | Item# | Description | QTY | Unit price | Cust # | Cust Name |
11 | 5/7 | 30 | Washer | 5 | $350 | 22 | Brown |
31 | Dryer | 8 | $370 | ||||
12 | 5/8 | 10 | TV | 4 | $250 | 26 | Henry |
13 | 5/10 | 20 | VCR | 10 | $180 | 24 | Thomas |
21 | CD | 10 | $190 | ||||
14 | 5/12 | 10 | TV | 15 | $250 | 22 | Brown |
Please show all steps of getting to the third normalization!
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