What normal form is satisfied by these rules?

You are employed as a developer at ABC.com.
You are in the process of developing a new database for ABC.com. You are informed that the new
databases tables should satisfy the following normalization rules:
Repeating groups in individual tables should be removed.
A separate table should be created for every array of related data.
Every array of related data should be identified with a primary key.
Separate tables should be created for arrays of values that pertain to multiple data.
These tables should be linked with a foreign key.
What normal form is satisfied by these rules?

You are employed as a developer at ABC.com.
You are in the process of developing a new database for ABC.com. You are informed that the new
databases tables should satisfy the following normalization rules:
Repeating groups in individual tables should be removed.
A separate table should be created for every array of related data.
Every array of related data should be identified with a primary key.
Separate tables should be created for arrays of values that pertain to multiple data.
These tables should be linked with a foreign key.
What normal form is satisfied by these rules?

A.
1 NF

B.
2 NF

C.
3 NF

D.
4 NF



Leave a Reply 1

Your email address will not be published. Required fields are marked *