Scribd
Upload
4 views1 page

Database Normalization for Customer Billing

The document outlines the normalization process of a database involving customers, payments, and bills. It details the transition from unnormalized form (UNF) to first normal form (1NF), second normal form (2NF), and third normal form (3NF), addressing issues such as multivalued attributes and transitive dependencies. The final structure includes separate sets of attributes for customer and bill information without any redundancy.

Uploaded by

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

Database Normalization for Customer Billing

The document outlines the normalization process of a database involving customers, payments, and bills. It details the transition from unnormalized form (UNF) to first normal form (1NF), second normal form (2NF), and third normal form (3NF), addressing issues such as multivalued attributes and transitive dependencies. The final structure includes separate sets of attributes for customer and bill information without any redundancy.

Uploaded by

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

Customer----*----Pays----*----Bill

UNF:
pays (c_id,c_name, c_phone no, c_address,b_id, b_no, b_date, b_name, start
date)
1NF:

c_phone is multivalued attributes.


c_id,c_name, c_phone no, c_address,b_id, b_no, b_date, b_name, start
date
2NF:
 c_id,c_name, c_phone no, c_address
 b_id, b_no, b_date, b_name, start date
3NF:
There is no transitive dependency
 c_id,c_name, c_phone no, c_address
 b_id, b_no, b_date, b_name, start date

You might also like