Physical Design

Question 1

Normalisation rules up to 1NF

Answer 1

First Normal Form (1NF):

Eliminate duplicate rows.
Identify a primary key for each table.
Remove repeating groups and create separate tables for them.

Question 2

Normalisation rules up to 2NF

Answer 2

Second Normal Form (2NF):

Meet the requirements of 1NF.
Ensure that all non-key attributes depend on the entire primary key.
Move partial dependencies to separate tables.

Question 3

Normalisation rules up to 3NF

Answer 3

Third Normal Form (3NF):

Meet the requirements of 2NF.
Eliminate transitive dependencies.
Remove attributes that are not directly dependent on the primary key.

Question 4

Boyce-Codd notation