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

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.

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok