In a relational database, which one of the following is CORRECT?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. A relation with only two attributes is always in BCNF.
Explanation
Any binary relation is in BCNF: every non-trivial FD A → B makes A a key. A relation with only prime attributes is guaranteed 3NF but not necessarily BCNF. A relation can have no non-prime attributes, and BCNF decomposition is lossless but not always dependency preserving.More Database Management Systems questions
- Consider the following statements: A. A non-serial schedule is said to be conflict serializable if it is conflict-equivalent to some serial…
- What will be the right sequence of the phases of database design? A. Physical Design B. Conceptual Design C. Logical Design D. Requirement…
- An alternate key in a database table is also called
- In concurrency control, the phantom problem may occur when
- 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 i…
- 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…