Aspire's Library
A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET
Study Stuff for MCA Examinations - NIMCET
Previous Year Question (PYQs)
Consider the following statements:
A. A database design is in BCNF if each member of the set of relation schemas that constitutes the design is in BCNF
B. A BCNF schema can have transitive dependency
C. It is always possible to obtain a 3NF design without sacrificing a lossless join
D. There are multivalued dependencies in 4NF
Solution
A is correct because a database design is in BCNF when every relation schema in the design is in BCNF.
B is incorrect because BCNF removes dependency problems caused by non-super-key determinants.
C is correct because 3NF decomposition can be made lossless.
D is correct because 4NF deals with multivalued dependencies.
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Ask Your Question or Put Your Review.
