Scribd
Upload
8 views11 pages

Normalize Database to 3NF Guide

The document outlines the normalization process of a table up to the Third Normal Form (3NF). It starts with an unnormalized table containing order details, then progresses through First Normal Form (1NF) and Second Normal Form (2NF) to arrive at 3NF, which separates customer and product information into distinct tables. The final structure includes a Customer Table, a Products Table, and an OrderDetails Table linking orders to customers and products.

Uploaded by

raneerizal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views11 pages

Normalize Database to 3NF Guide

The document outlines the normalization process of a table up to the Third Normal Form (3NF). It starts with an unnormalized table containing order details, then progresses through First Normal Form (1NF) and Second Normal Form (2NF) to arrive at 3NF, which separates customer and product information into distinct tables. The final structure includes a Customer Table, a Products Table, and an OrderDetails Table linking orders to customers and products.

Uploaded by

raneerizal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Task: Normalize this table upto 3NF

OrderID CustomerName CustomerAddress

101 John Smith 123 Elm St, NY

102 Mary Johnson 456 Oak St, LA

103 Steve White 789 Pine St, SF

1NF

OrderDetails Table

OrderID CustomerName CustomerAddress

101 John Smith 123 Elm St, NY

101 John Smith 123 Elm St, NY

102 Mary Johnson 456 Oak St, LA

102 Mary Johnson 456 Oak St, LA

103 Steve White 789 Pine St, SF


103 Steve White 789 Pine St, SF

2NF:

Orders Table

OrderID CustomerName CustomerAddress

101 John Smith 123 Elm St, NY

102 Mary Johnson 456 Oak St, LA

103 Steve White 789 Pine St, SF

3NF:
Customer Table

CustomerID CustomerName CustomerAddress

1 John Smith 123 Elm St, NY

2 Mary Johnson 456 Oak St, LA

3 Steve White 789 Pine St, SF


ProductIDs ProductNames ProductPrices

201, 202 Laptop, Mouse 1000, 50

203, 204 Smartphone, 600, 150


Headphones

202, 205 Mouse, Keyboard 50, 80

ProductIDs ProductNames ProductPrices

201 Laptop 1000

202 Mouse 50

203 Smartphone 600

204 Headphones 150

202 Mouse 50
205 Keyboard 80

OrderDetails Table

OrderID ProductID

101 201

101 202

102 203

102 204

103 202

103 205
Products Table

ProductID ProductName

201 Laptop

202 Mouse

203 Smartphone

204 Headphones

205 Keyboard
Quantity TotalPrice

1, 2 1100

1, 1 750

2, 1 180

Quantity TotalPrice

1 1000

2 100

1 600

1 150

2 100
1 80

ProductName ProductPrice Quantity

Laptop 1000 1

Mouse 50 2

Smartphone 600 1

Headphones 150 1

Mouse 50 2

Keyboard 80 1
OrderDetails Table

ProductPrice OrderID CustomerID

1000 101 1

50 101 1

600 102 2

150 102 2

80 103 3

103 3
ProductID Quantity

201 1

202 2

203 1

204 1

202 2

205 1

You might also like