[go: up one dir, main page]
Scribd
Upload
9 views2 pages

Normalization of Relational Database

The document discusses the normalization of a customer record to reduce data redundancy in a relational database. It outlines the process of normalization, including the three acceptable forms: First, Second, and Third Form Normalization. The document presents both non-normalized and normalized tables for customer, supplier, and stock information.

Uploaded by

Blue Tech
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
9 views2 pages

Normalization of Relational Database

The document discusses the normalization of a customer record to reduce data redundancy in a relational database. It outlines the process of normalization, including the three acceptable forms: First, Second, and Third Form Normalization. The document presents both non-normalized and normalized tables for customer, supplier, and stock information.

Uploaded by

Blue Tech
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/ 2

Home exercise:

1.2. Normalize the following customer record


Customer Record
Customer No
Customer First name
Customer Surname
Address
Tel No
Supplier No
Supplier Name
Supplier Address
Stock No
Stock item
Stock cost
Description
Supplier Tel no
First, to normalize the above customer record lets first consider what is the process or normalization. Normalization help to
arranged or organize data to reduce data redundancy. Basically, there are three acceptable form of normalization in relational
database management system.
➢ First Form Normalization
➢ Second Form Normalization
➢ Third Form Normalization
Data Redundancy is the practice of data repeating itself in a record.
Second, to normalize the above record let present it in a horizontal table form.
Non-Normalize
C_no C_fn C_Sn Tel_no Supp_no Supp_name Supp_add Stock_no Stock_item Stock_cost Descrpt Supp_tel_no

Normalized Customer Table Normalized Supplier Table


C_no C_fn C_sn Tel_no Suppl_no Stock_no C_no Suppl_no Suppl_name Suppl_tel_no Suppl_add Stock_no

Normalized Stock Table


C_no Suppl_no Stock_no Stock-cost Stock-item Description

You might also like