Scribd
Upload
5 views2 pages

Normalization 2

The document outlines the normalization process of a database from 1NF to 3NF. It presents the structure of tables for Customers, Products, Orders, and OrderDetails, demonstrating how data is organized to eliminate redundancy. Each normalization form is illustrated with specific examples of data organization and relationships between tables.

Uploaded by

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

Normalization 2

The document outlines the normalization process of a database from 1NF to 3NF. It presents the structure of tables for Customers, Products, Orders, and OrderDetails, demonstrating how data is organized to eliminate redundancy. Each normalization form is illustrated with specific examples of data organization and relationships between tables.

Uploaded by

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

Normalization 2

1NF

OrderID CustomerName CustomerEmail ProductName ProductCategory Quantity Price OrderDate


1 Alice Smith alice@[Link] Laptop Electronics 1 1000 2023-03-01
2 Bob Jones bob@[Link] Headphones Electronics 2 150 2023-03-02
3 Alice Smith alice@[Link] Notebook Stationery 3 15 2023-03-05

2NF

TABLE: Customer

CustomerID CustomerName CustomerEmail

1 Alice Smith alice@[Link]

2 Bob Jones bob@[Link]

TABLE: Product

ProductID ProductName ProductCategory Price

1 Laptop Electronics 1000

2 Headphones Electronics 150

3 Notebook Stationery 15

TABLE: Order

OrderID CustomerID ProductID Quantity OrderDate


1 1 1 1 2023-03-01
2 2 2 2 2023-03-02
3 1 3 3 2023-03-05

3NF

TABLE: Customer

CustomerID CustomerName CustomerEmail

1 Alice Smith alice@[Link]

2 Bob Jones bob@[Link]

TABLE: Product

ProductID ProductName ProductCategory Price


1 Laptop Electronics 1000

2 Headphones Electronics 150

3 Notebook Stationery 15

TABLE: Order

OrderID CustomerID OrderDate


1 1 2023-03-01
2 2 2023-03-02
3 1 2023-03-05

TABLE: OrderDetails

OrderID ProductID Quantity


1 1 1
2 2 2
3 3 3

You might also like