If the attribute of relation schema R is not a member of some candidat – McqOptions

MCQOPTIONS

1.	If the attribute of relation schema R is not a member of some candidate key then this type of attribute is classified as
A.	Nonprime attribute
B.	Prime attribute
C.	Atomic attribute
D.	Candidate attribute
Answer» B. Prime attribute

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