Test 2 Study

A relation in this form is free of all modification anomalies

Domain/key normal form.

Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

Weak entity.

An attribute is a(n):

column of a table.

A relation is considered a:

two-dimensional table.

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

(A,B) is a composite determinant.

Which of the following is NOT a basic element of all versions of the E-R model:

Primary Keys

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Supertype entity.

A recursive relationship is a relationship between an entity and ____________?

itself.

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

modification anomalies.

Row is synonymous with the term:

record.

Table is synonymous with the term:

relation.

One solution to the multivalues dependency constraint problem is to:

split the relation into two relations, each with a single theme.

Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?

ID-dependent entity.

Which of the following is a group of one or more attributes that uniquely identifies a row:

Key

Properties that describe the characteristics of entities are called:

attributes.

Entities of a given type are grouped into a(n):

entity class.

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

foreign keys.

A key:

identifies a row.

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

normal forms.

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) _______ entity.

parent.

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):

referential integrity constraint.

If a table has been normalized so that all determinants are candidate keys, then that table is in:

BCNF

Which of the following indicates the maximum number of entities that can be involved in a relationship?

Maximum cardinality.

Which of the following is not a restriction for a table to be a relation:

The columns must be ordered.

A functional dependency is a relationship between or among:

attributes.

The primary key is selected from the:

candidate keys.

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

fourth normal form.

A tuple is a(n):

row of a table.