Database Concepts Quiz

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

• A → B.

• A → C.

• A → (B, C).

• (B, C) → A.

Different relation classes created by techniques to prevent modification anomalies are called:

• Normalization forms.

• Referential integrity constraints.

• Functional dependencies.

• None of the above.

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

• Second normal form.

• Third normal form.

• Fourth normal form.

• Domain/key normal form.

When values in one or more attributes are used as foreign keys, they must exist in another set of one or more attributes in another table, we have created a:

• Transitive dependency.

• Insert anomaly.

• Referential integrity constraint.

• Normalization form.

In the relational model, relationships between relations or tables are created using:

• Composite keys.

• Determinants.

• Candidate keys.

• Foreign keys.

A functional dependency is a relationship between:

• Tables.

• Rows.

• Relations.

• Attributes.

A table is synonymous with the term:

• Record.

• Relation.

• Column.

• Field.

For some relations, modifying data can have undesirable consequences called:

• Referential integrity constraint.

• Modification anomalies.

• Normalization form.

• Transitive dependencies.

A relation in this form has no modification anomalies:

• First normal form.

• Second normal form.

• Third normal form.

• Domain/key normal form.

A DBMS acts as an interface between which two components of an enterprise database system?

• Database applications and databases.

• Data and databases.

• Users and database applications.

• Database applications and SQL.