Question

What are the conditions that must be full fill for 2NF, explain the implication of 1NF?

Note: this question its for fundimental database subject I need defferent answer to avoid high percentage of plegrisem

Answer 1

****This requires some effort so please drop a like if you are satisfied with the solution****

Conditions for 2NF:

A table is said to be in 2NF ( 2nd Normal Form ) if it satisfies the following conditions:

1. Table is in 1NF
2. No non prime attribute is dependent on prime attributes (subset of candidate key)

sub_id	sub	prof_age
1	Mat	26
1	Phy	26
2	Bio	26
3	Phy	31
3	Che	31

Candidate key: {sub_id, sub}

Non-prime attribute : prof_age

The above table is in 1 NF as all attributes has atomic values but it is not in 2 NF because non prime attribute prof_age is dependent on subset if candidate key sub_id.

For a table to be in 1 NF Its attributes must not have multiple values or attributes must be atomic values.