Question

types of normalization​

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)

〒_〒

Answer 2

Answer:

$\huge{\underline{\underline{\boxed{\sf{\purple{answer}}}}}}$

In this quick introduction to database normalization, we include the definition of the normal forms:

1st Normal Form (1NF) A table (relation) is in 1NF if: ...

2nd Normal Form (2NF) ...

3rd Normal Form (3NF) ...

Boyce-Codd Normal Form (BCNF) ...

4th Normal Form (4NF) ...

5th Normal Form (5NF) ...

Domain-Key Normal Form (DKNF)

Mar 9, 2018