Fill in the blank: A relation is in ______ if it contains composite or multi-valued attributes. | Card: 5 / 20 |
Which of the following is a property of a non-trivial functional dependency? A) X → Y is trivial if Y is a subset of X B) X → Y is non-trivial if Y is not a subset of X C) Both A and B D) None of the above | Card: 7 / 20 |
Riddle: I eliminate redundancy and help avoid anomalies, but I require a careful design of relations. What am I? | Card: 9 / 20 |
![]() Unlock all Flashcards with EduRev Infinity Plan Starting from @ ₹99 only |
In which normal form does a relation not have any transitive dependency for non-prime attributes? | Card: 11 / 20 |
True or False: A relation is in Boyce-Codd Normal Form (BCNF) if for every functional dependency, the left-hand side is a super key. | Card: 13 / 20 |
Fill in the blank: A relation is in ______ if it is in 3NF and has no non-trivial multivalued dependencies. | Card: 15 / 20 |
What is the highest normal form that a relation can achieve if it contains partial dependencies? | Card: 17 / 20 |
Which functional dependency property states that if X → Y and Y → Z, then X → Z? A) Augmentation B) Reflexivity C) Transitivity D) Union | Card: 19 / 20 |






