The property of normalization of relations which guarantees that funct – McqOptions

MCQOPTIONS

1.	The property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as
A.	Nonadditive join property
B.	Independency reservation property
C.	Dependency preservation property
D.	Additive join property
Answer» D. Additive join property

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