please answer these two questions with an explanation thanks

please answer these two questions with an explanation.
thanks

41. Explain normalization and its different forms. 42. What steps are involved in the conversion to third normal form?

Solution

1.Normalisation is the process to organise database to reduce duplicacy and improve data integrity.

Different forms of Normalisation:

1st Normal form: As per this form, no two rows could have the same data.

2nd Normal Form: There should not be partial dependecy of any column on primary key. If there is a concatenated primary key, the other columns must depend on the whole concatenated key for their existence.

3rd Normal Form: All the non primary keys of the table must depend on the primary keys.

BCNF: It is based on the concept of determinant.
i). A determinant is any attribute on which some other attribute is fully functionally dependent.
ii). A relation is in BCNF is, and only if, every determinant is a candidate key.

2. Firstly, Identify if there is any dependency of non key attributes in each table.
If it is, Then remove these columns to form a new table.
There should be one common column in both tables that acts like a foreign key.