Which of the following is the only true statement about functional dependencies?

Question

Which of the following is the only true statement about functional dependencies? ________

i. the attributes in a functional dependency can come from different relational schemas

ii. there can be at most one attribute on either side of a functional dependency

iii. functional dependencies can involve relation names as well as attributes

iv. a key constraint is a kind of functional dependency

If a b is a functional dependency for a relational schema, then is b a also a functional dependency for that relational schema? a) yes b) no c) it would depend on the schema___________

Suppose a relational schema has just two attributes. Is it guaranteed to be in Boyce Codd Normal Form? a) yes b) no _____________

Explanation / Answer

ii. there can be at most one attribute on either side of a functional dependency

c) it would depend on the schema

a) yes

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.