DB Revision

A two-dimensional table of data sometimes is called a

• Group

• Relation

• Set

• declartion

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

• Business rule constraint

• Data integrity

• Business integrity

• Data Structure

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

• Foreign Key

• Primary Key

• Column

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

• foreign key

• composite key

• multivalued key.

• cardinal key.

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

• create session

• create table

• create index

• select

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

• minimize data redundancy.

• simplify the enforcement of referential integrity.

• maximize storage space.

• make it easier to maintain data.

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

• First Normal Form

• Second Normal Form

• Third Normal Form

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?

• First

• Second

• Third

• Fourth

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

• attribute dependency.

• functional dependency.

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

• partial functional dependency.

• partial nonkey dependency

• transitive dependency