A form of database specification which maps conceptual requirements is called:

Data is represented in the form of:

A two-dimensional table of data sometimes is called a:

_______ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

A primary key whose value is unique across all relations is called a(n):

A primary key that consists of more than one attribute is called a:

In the SQL language, the ________ statement is used to make table definitions.

In the figure, the primary key for Order Line is which type of key?

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

A domain definition consists of all of the following components EXCEPT:

Which of the following are properties of relations?

Which of the following violates the atomic property of relations?

The entity integrity rule states that:

The ________ states that no primary key attribute may be null.

In the figure, Customer_ID in the CUSTOMER table is which type of key?

All of the following are the main goals of normalization EXCEPT:

When all multivalued attributes have been removed from a relation, it is said to be in:

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

The normal form which deals with multivalued dependencies is called:

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

A constraint between two attributes is called a(n):

A candidate key must satisfy all of the following conditions EXCEPT:

The attribute on the left-hand side of the arrow in a functional dependency is the:

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.

A functional dependency between two or more nonkey attributes is called a:

________ problems are encountered when removing data with transitive dependencies.

The need to ________ relations commonly occurs when different views need to be integrated.

Two or more attributes having different names but the same meaning are called:

An attribute that may have more than one meaning is called a(n):

An alternative name for an attribute is called a(n):

Understanding the steps involved in transforming EER diagrams into relations is important because:

A nonkey attribute is also called a(n):

When a regular entity type contains a multivalued attribute, one must:

In the figure, what type of relationship do the relations depict?

In the figure, what type of relationship do the relations depict?

In the figure below, what is depicted?

In the figure below, what type of key is depicted?

Referring to the figure below, which of the following is NOT true?

The figure below is an example of mapping which type of relationship?

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

_____ are anomalies that can be caused by editing data in tables.

A relation that contains minimal redundancy and allows easy use is considered to be:

Data structures include data organized in the form of tables with rows and columns.

A composite key consists of only one attribute.

A primary key is an attribute that uniquely identifies each row in a relation.

A foreign key is a primary key of a relation that also is a primary key in another relation.

Sample data are useful for developing prototype applications and for testing queries.

An enterprise key is a foreign key whose value is unique across all relations.

One property of a relation is that each attribute within a relation has a unique name.

There can be multivalued attributes in a relation.

The columns of a relation can be interchanged without changing the meaning or use of the relation.

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

All values that appear in a column of a relation must be taken from the same domain.

View integration is the process of merging relations together.

A synonym is an attribute that may have more than one meaning.

When two or more attributes describe the same characteristic of an entity, they are synonyms.

CASE tools can model more complex data relationships, such as ternary relationships.

When a regular entity type contains a multivalued attribute, two new relations are created.

When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

When transforming a one-to-one relationship, a new relation is always created.

If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations.

An identifier assigned to an associative entity is also called a cross-relation key.

each employee has exactly one manager.

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

The relational data model does, at this time, directly support subtype/supertype relationships.

Data integrity consists of powerful operations to manipulate data stored in relations.

The allowable range of values for a given attribute is part of the domain constraint.

The entity integrity rule states that a primary key attribute can be null.

In the relational data model, associations between tables are defined through the use of primary keys.

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

A cascading delete removes all records in other tables associated with the record to be deleted.

Select True or False: The truncate table statement in SQL creates a new table.

Select True or False: A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

Select True or False: An anomaly is a type of flaw in the database server.

Select True or False: When normalizing, the goal is to decompose relations with anomalies to produce smaller, well-structured relations.

Select True or False: A relation in fifth normal form may not contain any anomalies.

Select True or False: A co-dependency is a constraint between two attributes or two sets of attributes.

Select True or False: A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

Select True or False: A relation is in first normal form if it has no more than one multivalued attribute.

Select True or False: A partial functional dependency is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.

Select True or False: A transversal dependency is a functional dependency between two or more nonkey attributes.

Select True or False: Anomalies do not generally arise out of transitive dependencies.