Answered step by step
Verified Expert Solution
Link Copied!

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

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

Fundamental Financial Accounting Concepts

Authors: Thomas P. Edmonds

11th Edition

1260786587, 9781260786583

More Books

Students also viewed these Accounting questions