Question: what is 2nf in dbms with example?
Answer: Second normal form (2NF) ... A relation is in second normal form if it is in 1NF and every non key attribute is fully functionally dependent on the primary key. A university uses the following relation: Student(IDSt, StudentName, IDProf, ProfessorName, Grade) The attributes IDSt and IDProf are the identification keys.