Which of the following is desirable in a database design with function – McqOptions

MCQOPTIONS

1.	Which of the following is desirable in a database design with functional dependencies?
A.	BCNF
B.	Losslessness
C.	Dependency preservation
D.	All of the mentioned
Answer» B. Losslessness

Discussion

No Comment Found

Related MCQs

Which of the following normal forms does not exist?
State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency.
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies
STATE_TRUE_OR_FALSE:_IF_A_RELATIONAL_SCHEMA_IS_IN_________NF_AND_A_IS_A_SUBSET_OF_R_AND_B_IS_ALSO_A_SUBSET_OF_R_THEN_IT_IS_THAT_A_IS_A_SUPERKEY_IS_A_TRIVIAL_MULTI_VALUES_DEPENDENCY.?$
Which of the following normal forms does not exist?$
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencie?
Functional dependencies are sometimes referred to as ________
Multi valued dependencies are also called as __________
State true or false: Most current database systems do not support constraints on materialized view
State true or false: SQL specifies a way of mentioning functional dependencies