Which of the following is/are FALSE statement(s)?
A. An all-key relation is always in BCNF since it has no FDs.
B. A relation that is not in 4NF due to a nontrivial MVD must be decomposed to convert it into a set of relations in 4NF.
C. The decomposition removes the redundancy caused by the MVD.
D. 3NF is stronger than BCNF.
Choose the correct answer from the options given below:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. D only
Explanation
An all-key relation has no non-trivial FDs, so it is in BCNF (A true). B and C describe 4NF decomposition correctly. D is false: BCNF is stronger (stricter) than 3NF.More Database Management Systems questions
- Which of the following commands can be used to modify data in an SQL table? A. INSERT B. DELETE C. UPDATE D. SELECT Choose the correct answ…
- Which of the following tables contains the primary information in a data warehouse?
- The INSERT command is used to A. add a single tuple to a relation B. add multiple tuples to a relation C. add values to specific attributes…
- Match List I with List IIList I List II A. Hadoop Distributed File System I. Trust B. Veracity II. Facebook C. Apache Pig III. Name-Node D.…
- The degree of a relation in a database is
- Match List I with List IIList I List II A. Project Join Normal Form I. Concurrency B. The lost update problem II. Fifth Normal Form C. Disc…