You are looking at the next step in the database design process—specifically, logical data modeling.Normalization is avery important task in this step. For this assignment,include the following...

NORMALIZATION is a bottom up approach in which one follows step-by-step process in order
to decompose a complex relation into simple relations. The basic motive is to remove
inconsistency, uncertainty and redundancy if any present in database design.

Four most commonly used normal forms are first (1NF), second (2NF), third (3NF) and
BCNF(Boyce-Codd normal ) forms.


Properties of each Normal Form

1. A relation schema R is in 1NF if and only if: - All the attributes of R are atomic in nature.

2. A Relation R is in Second Normal Form if and only if :
a. R is already in 1NF
b. There is no partial dependency in R which exists between non-key attributes and
key attributes.

3. A relation R is said to be in the Third Normal Form (3NF) if and only if:

a. It is in 2NF
b. There is no transitive dependency which exists between non-key attributes and
key attributes...