What are the 3rdand 4th forms of normalization, explain with examples?

Question

Mylee Church

Computers & Technology

6 April, 21:43

What are the 3rdand 4th forms of normalization, explain with examples?

+3

Answers (1)

Know the Answer?

Finn · Answer 1

Normalization is a technique in which database are designed and organizes tables in such manner that reduces dependency and redundancy of the data. It can divide larger tables into the smaller tables and used them using different relationships.

3rd form of normalization is defined as, the table whose non primary key field are dependent on the primary key only and have no dependence any other non key primary field in the tables.

4th form of normalization is defined as, is used in database normalization where they are a non trivial multi value dependency other than candidate key. It builds on the first, second and third normal forms and the Boyce Codd Normal Form.