What is 1nf 2nf 3nf in dbms?



What is 1nf 2nf 3nf in dbms?..

Answer / Kulveer Singh

1NF (First Normal Form): A table has no repeating groups and each column contains atomic or indivisible values. 2NF (Second Normal Form): A table is in 1NF and every non-key attribute is fully dependent on the primary key. 3NF (Third Normal Form): A table is in 2NF and there are no transitive dependencies.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Explain concurrency transparency.

1 Answers  


Can I concurrently access a firebird database with embedded and with regular server?

1 Answers  


How to specify transaction or query timeout?

1 Answers  


Is the internet a database?

1 Answers  


Enlist various transaction phases.

1 Answers  


What is equi-join?

1 Answers  


What are 4 types of models?

1 Answers  


How to prevent firebird.log file from filling up the disk partition?

1 Answers  


Explain snapshot replication.

1 Answers  


What is difference between database and file?

1 Answers  


How is data stored in a relational database?

1 Answers  


What do you mean by transparent dbms?

1 Answers  


Categories