A table has fields F1, F2, F3, F4, and F5, with the following function – McqOptions

MCQOPTIONS

1.	A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:F1->F3F2->F4(F1,F2)->F5in terms of normalization, this table is in
A.	1NF
B.	2NF
C.	3NF
D.	None of the mentioned
Answer» B. 2NF

Discussion

No Comment Found

Related MCQs

A function that has no partial functional dependencies is in _______ form :
4NF is designed to cope with :
5NF is designed to cope with :
A BCNF is :
Every Boyee-Codd normal form is in
Designers use which of the following to tune performance of systems to support time-critical operations?
In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:F1->F3F2->F4(F1,F2)->F5in terms of normalization, this table is in
Consider the following functional dependencies in a database. Date_of_Birth->Age Age->Eligibility Name->Roll_number Roll_number->Name Course_number->Course_name Course_number->Instructor (Roll_number, Course_number)->GradeThe relation (Roll_number, Name, Date_of_birth, Age) is