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

Q. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

View solution

Q. When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:

View solution

Q. Creating a read-only database is a task that is ________ assigned to beginning database professionals.

View solution

Q. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?

View solution