A functional dependency of the form X→Y is trivial if

Related MCQs

• Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
• Which of the following is the result of a transitive dependency?
• One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme.
• Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?
• How many inference rules are there for functional dependencies?
• The DML provides following functional access to the database:
• A table that contains one or more repeating groups is in which normal form?
• A relation is in this form if it is in BCNF and has no multivalued dependencies:
• Which of the following is not a relational algebraic operation that is not form the set theory?