Question

Explain the Normalization and its types.

Answer 1

Normalisation is a process of organising data in data base which remove s the data redundancy, insertion anomaly ,update and delete anomaly. in the process, checking of relation schema is done against in the normal forms to know that, it is a satisfying any normal form or not. if a relational schema is not satisfying any normal form than we devide it into small schemas.

there r various types-

1st normal form

2nd normal form

3rd normal form

BCNF(boyc codd normal form)