Programming - Normalize Database SQL Table

FratBro23
Category:
Programming
Price: $10 USD

Question description



 

Order


 

ID


 

 

Customer


 

ID


 

 

Customer


 

Name


 

 

BrandID


 

 

BrandName


 

 

Model


 

Number


 

 

Model


 

Name


 

 

QTY


 

 

o1


 

 

c01


 

 

RHE


 

 

01


 

 

Brand1


 

 

m01


 

 

MM1


 

 

2


 

 

o1


 

 

c01


 

 

RHE


 

 

01


 

 

Brand2


 

 

m02


 

 

MM2


 

 

1


 

 

o2


 

 

c02


 

 

EVK


 

 

02


 

 

ICT


 

 

m03


 

 

MM2


 

 

2


 

 

o2


 

 

c02


 

 

EVK


 

 

02


 

 

ICT


 

 

m02


 

 

MM3


 

 

3


 

 

o2


 

 

c02


 

 

EVK


 

 

02


 

 

ICT


 

 

m04


 

 

MM4


 

 

1


 

 

o3


 

 

c01


 

 

HAK


 

 

03


 

 

AI


 

 

m03


 

 

MM1


 

 

4


 

 

o3


 

 

c01


 

 

HAK


 

 

03


 

 

AI


 

 

m04


 

 

MM2


 

 

2


 

 

o3


 

 

c01


 

 

HAK


 

 

03


 

 

AI


 

 

m01


 

 

MM5


 

 

1


 


How can this table be normalized to 1NF, 2NF AND 3NF, please explain

 

Thanks.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UC Berkeley
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors