A relation is in BCNF if for every functional dependency X → Y, X is a superkey. In this case, with FDs A → B, B → C, and C → D, and {A} as the primary key (and thus the only candidate key and superkey), the dependencies B → C and C → D violate the BCNF condition because neither B nor C are superkeys. Therefore, the relation is not in BCNF.
Consider a relation with attributes {A, B, C, D} and the following functional dependencies: A → B, B → C and C → D. If A is the primary key, which of the following is true regarding BCNF?
Asked in Programmer Exam 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
Show answer
Answer: C. The relation is not in BCNF.
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- The number of attribute in a relation is known as -
- Which operation requires two relations as input to form a new relation and these two relations must have a common attribute?
- The complete picture of data stored in database is known as
- Consider the following pairs of name of famous person and name of the company associated with : 1. Elon Musk : Apple 2. Jeff Bezos : Amazon 3. Tim Cook : Tesla Which of the pairs given above is/are correctly matched?
- Which of the following is/are correct with regard to Supercomputing in India ?
- Which one of the following pairs is not matched?
- Who among the following owns an Oppo mobile phone?
- Which of the given combinations is correct?
All 1,360 Information and Communication Technology questions →