Q. A functional dependency between two or more non-key attributes is called

View solution

Q. A table that displays data redundancies yields ____________ anomalies

View solution

Q. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

View solution

Q. The different classes of relations created by the technique for preventing modification anomalies are called:

View solution

Q. A relation is in this form if it is in BCNF and has no multivalued dependencies:

View solution

Q. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

View solution

Q. A functional dependency is a relationship between or among:

View solution

Q. For some relations, changing the data can have undesirable consequences called:

View solution

Q. A relation in this form is free of all modification anomalies.

View solution

Q. If attributes A and B determine attribute C, then it is also true that:

View solution

Q. If attribute A determines both attributes B and C, then it is also true that:

View solution

Q. One solution to the multivalued dependency constraint problem is to:

View solution

Q. A function that has no partial functional dependencies is in _______ form :

View solution

Q. 4NF is designed to cope with :

View solution

Q. 5NF is designed to cope with :

View solution

Q. A BCNF is :

View solution

Q. Every Boyee-Codd normal form is in

View solution

Q. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

View solution

Q. Eliminating modification anomalies is a(n) ________ of normalization.

View solution

Q. Multivalued dependencies should ________ be eliminated.

View solution