What is third normal form in SQL ?

To be in third normal form i.e 3NF , non key field should not depend on other non key field. In other words, third normal form does not permit any strictly informational attribute to depend upon anything other than a superkey.

What is second normal form in SQL ?

To be in second normal form i.e 2NF , all information attributes or fields of the table are attributes of entity of table schema. All information fileds in the table is directly related to entire primary key or entity of table.

What is first normal form in SQL ?

To be in first normal formal i.e 1NF , each fields in table should be atomic and unique. There should not be any duplicate information.

What are characterstics of well designed normalized database ?

Characteristics of well designed normalized database are :

1. Table should have identifier
2. Table should store data for single type of entity
3. Table should not have repeating values or columns
4. Table should avoid nullable columns

What is noramaization and different types of normalization ?

Normalization is set of rules to design tables and table relationships. Normalized database would have large number of narrow tables i.e with less number of columns.

There are 3 types of normalization :

1. First Normal Form
2. Second Normal Form
3. Third Normal Form