What is 2nf in dbms?



What is 2nf in dbms?..

Answer / Saroj Kumar Thakur

2NF (Second Normal Form) in DBMS refers to a level of normalization of a database in which every non-key attribute is fully dependent on the primary key and not part of a transitive dependency.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  


Name the two files that are created when you generate a form ?

1 Answers  


Differentiate nested loop, hash join and merge join.

1 Answers  


What is the meaning of flat file database?

1 Answers  


What does rdbms stand for?

1 Answers  


What are the database skills?

1 Answers  


What is a candidate key in a database?

1 Answers  


Define the relationship between ‘view’ and ‘data independence’.

1 Answers  


How does a database partition work?

1 Answers  


Explain the term generalization.

1 Answers  


Explain issues for database performance.

1 Answers  


Is this statement true or false? All databases must be in third normal form?

1 Answers  


Categories