Database Concepts Chapter 4

Which of the following are properties of relations?

-Unique name -Every attribute value must be atomic -Every row must be unique -Columns must have unique names -The order of the rows and columns must be irrelevant

True or False: Data integrity consists of powerful operations to manipulate data stored in relations.

?

True or False: Data structures include data organized in the form of tables with rows and columns.

?

An alternative name for an attribute

Alias

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

CREATE TABLE

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

Composite PK

The relational data model consists of which components?

Data structure (tables), manipulation (SQL), and integrity

A non-key attribute is also called a(n)

Descriptor

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

Determinant

A domain definition consists of the following components:

Domain name, meaning, data type, size (or length), and allowable values/range (if applicable)

A primary key whose value is unique across all relations

Enterprise key

The ________ states that no primary key attribute may be null

Entity integrity constraint

True or False: A composite key consists of only one attribute.

False

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

First Normal Form

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

Foreign Key

A constraint between two attributes is called a(n)

Functional dependency

An attribute that may have more than one meaning

Homonym

Which of the following anomalies results from a transitive dependency?

Insertion, Deletion, and Modification

Which of the following are anomalies that can be caused by redundancies in tables?

Insertion, deletion, and modification

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

Integrity

All of the following are the main goals of normalization EXCEPT

Maximize storage space

The entity integrity rule states that

No primary key attribute may be null. All primary key fields MUST contain data values.

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

Partial functional

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

Primary Key

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

Referential integrity constraint

A two-dimensional table of data sometimes is called a

Relation

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

Remove them

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

Second

Two or more attributes having different names but the same meaning

Synonyms

A functional dependency between two or more non-key attributes

Transitive dependency

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

Well-structured

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

if you do it incorrectly, you won't have a well-structured relation.

A candidate key must satisfy all of the following conditions EXCEPT

the key must indicate the row's position in the table