Scribd
Upload
22 views17 pages

Normalization Example Beta

The document provides an example of database normalization, illustrating the process from unnormalized form through First Normal Form (1NF), Second Normal Form (2NF), to Third Normal Form (3NF) using an order management system for ABC Company. It outlines the rules for each normalization stage, including the elimination of repeating groups, partial dependencies, and transitive dependencies. Additionally, it includes an entity-relationship diagram to represent the relationships between orders, items, and customers.

Uploaded by

echo.gab7
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
22 views17 pages

Normalization Example Beta

The document provides an example of database normalization, illustrating the process from unnormalized form through First Normal Form (1NF), Second Normal Form (2NF), to Third Normal Form (3NF) using an order management system for ABC Company. It outlines the rules for each normalization stage, including the elimination of repeating groups, partial dependencies, and transitive dependencies. Additionally, it includes an entity-relationship diagram to represent the relationships between orders, items, and customers.

Uploaded by

echo.gab7
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
You are on page 1/ 17

COLLEGE OF ENGINEERING AND INDUSTRIAL TECHNOLOGY

INFORMATION TECHNOLOGY DEPARTMENT

ITC210 | Information Management


ITE212 | Web Systems and Technologies

Database Normalization Example (1NF up to 3NF)


ABC Company
xxxxxxxxxxxxxxxxxx

Order No.
header Order Date
Customer ID
Customer Name
Customer Address

Item No. Item Name Item Quantity Item Price Item Total

line items

Total Amount: ______________


Unnormalized Form

Order
Order No.
Order Date
Customer ID
Customer Name
Customer Address
Item No.
Item Name
Item Quantity
Item Price
Item Total
Total Amount
First Normal Form (1NF)
Rule: No repeating groups of elements.

Order
Order No.
Order Date
Customer ID
Customer Name
Customer Address
Item No.
Item Name
Item Quantity
Item Price
Item Total
Total Amount
First Normal Form (1NF)
Rule: No repeating groups of elements.

Order
Order No.
Order Date
Customer ID
Customer Name
Customer Address
Item No.
Item Name
Item Quantity Repeating
Item Price Elements
Item Total
Total Amount
First Normal Form (1NF)
Rule: No repeating elements.

Order Order Order_Item


Order No.
Order Date
Customer ID Order No.
Order No.
Customer Name Order Date
Item No.
Customer Address Customer ID
Item Name
Item No. Customer Name
Item Quantity
Item Name Customer Address
Repeating Item Price
Item Quantity Total Amount
Elements Item Total
Item Price
Item Total
Total Amount
First Normal Form (1NF)
Rule: No repeating elements.

Order Order_Item

Order No.
Order No.
Order Date Second Normal Form (2NF)
Item No.
Customer ID Rule: No partial dependencies.
Item Name
Customer Name
Item Quantity
Customer Address
Item Price
Total Amount
Item Total
First Normal Form (1NF)
Rule: No repeating elements.

Order Order_Item

Order No.
Order No.
Order Date Second Normal Form (2NF)
Item No.
Customer ID Rule: No partial dependencies.
Item Name partially
Customer Name
Item Quantity dependent
Customer Address
Item Price attributes
Total Amount
Item Total
First Normal Form (1NF) Second Normal Form (2NF)
Rule: No repeating elements. Rule: No partial dependencies.

Order Order_Item Order_Item Item Order

Order No. Order No.


Order No.
Order Date Order Date
Item No. Order No.
Customer ID Item No. Customer ID
Item Name Item No.
Customer Name Item Name Customer Name
Item Quantity Item Quantity
Customer Address Item Price Customer Address
Item Price Item Total
Total Amount Total Amount
Item Total
Second Normal Form (2NF)
Rule: No partial dependencies.

Order_Item Item Order

Order No.
Order Date
Order No.
Item No. Customer ID
Item No. Third Normal Form (3NF)
Item Name Customer Name
Item Quantity Rule: No transitive dependencies.
Item Price Customer Address
Item Total
Total Amount
Second Normal Form (2NF)
Rule: No partial dependencies.

Order_Item Item Order

Third Normal Form (3NF)


Order No. Rule: No transitive dependencies.
Order Date
Order No.
Item No. Customer ID
Item No. transitively
Item Name Customer Name
Item Quantity dependent
Item Price Customer Address
Item Total attributes
Total Amount
Second Normal Form (2NF) Third Normal Form (3NF)
Rule: No partial dependencies. Rule: No transitive dependencies.

Order_Item Item Order Order Customer

Order No.
Order Date Order No.
Order No. Customer ID
Item No. Customer ID Customer ID (FK)
Item No. Customer Name
Item Name Customer Name Order Date
Item Quantity Customer Address
Item Price Customer Address Total Amount
Item Total
Total Amount
Third Normal Form (3NF)
Rule: No transitive dependencies.

Order Order_Item Item Customer

Order No.
Order No. Customer ID
Customer ID (FK) Item No.
Item No. Customer Name
Order Date Item Name
Item Quantity Customer Address
Total Amount Item Price
Item Total

Another 3NF Rule: No derived attributes.


Third Normal Form (3NF)
Rule: No transitive dependencies.

Order Order_Item Item Customer

Order No.
Order No. Customer ID
Customer ID (FK) Item No.
Item No. Customer Name
Order Date Item Name
Item Quantity Customer Address
Total Amount Item Price
Item Total

Another 3NF Rule: No derived attributes.


Third Normal Form (3NF)
Rule: No transitive dependencies.

Order Order_Item Item Customer

Order No. Customer ID


Order No. Item No.
Customer ID (FK) Customer Name
Item No. Item Name
Order Date Customer Address
Item Quantity Item Price

Another 3NF Rule: No derived attributes.


ENTITY-RELATIONSHIP DIAGRAM

Order Item
Order No. (PK) Item No. (PK)

Customer ID (FK) Item Name


Order Date Item Price

Order_Item
OrderNo. Item No. (PK)

Customer Item Quantity


Customer ID (PK)
Customer Name
Customer Address

You might also like