Question

Define normalisation? explain 1nf, 2nf, 3nf of the normalisation?

Answer 1

Normalization is the process of reorganizing data in a database so that it meets two basic requirements: (1) There is no redundancy of data (all data is stored in only one place), and (2) data dependencies are logical (all related data items are stored together). Normalization is important for many reasons, but chiefly because it allows databases to take up as little disk space as possible, resulting in increased performance.
Normalization is also known as data normalization.
The three main types of normalization are listed below. Note: "NF" refers to "normal form."

1NF

2NF

3NF
hope it helps u