Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications.

Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications.

Answer: FALSE

Multiple key retrieval is possible with the hashed file organization.

Multiple key retrieval is possible with the hashed file organization.

Answer: FALSE

Random key retrieval on the primary key is comparatively slow with the hashed file organization.

Random key retrieval on the primary key is comparatively slow with the hashed file organization.

Answer: FALSE

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

Answer: TRUE

When using the sequential file organization, the addition of rows requires rewriting the file.

When using the sequential file organization, the addition of rows requires rewriting the file.

Answer: TRUE

A physical file is a named set of table rows stored in a contiguous section of secondary memory.

A physical file is a named set of table rows stored in a contiguous section of secondary memory.

Answer: TRUE

Denormalization reduces the chance of errors introduced by normalizing relations.

Denormalization reduces the chance of errors introduced by normalizing relations.

Answer: FALSE

Generally speaking, a physical table corresponds to a relation.

Generally speaking, a physical table corresponds to a relation.

Answer: FALSE

A null value is used to represent the zero digit in a relation.

A null value is used to represent the zero digit in a relation.

Answer: FALSE

A derived field is a field that can be derived from other database fields.

A derived field is a field that can be derived from other database fields.

Answer: TRUE

A relation is said to be in second normal form when there are no transitive dependencies.

A relation is said to be in second normal form when there are no transitive dependencies.

Answer: FALSE

A relation is said to be in second normal form if the primary key consists of only one attribute.

A relation is said to be in second normal form if the primary key consists of only one attribute.

Answer: TRUE

An attribute can be functionally dependent on more than attribute.

An attribute can be functionally dependent on more than attribute.

Answer: TRUE

Normalization is based on an analysis of weak entities.

Normalization is based on an analysis of weak entities.

Answer: FALSE

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

Answer: FALSE

Referencing a relation, the sequence of columns cannot be interchanged without changing the meaning or use of the relation.

Referencing a relation, the sequence of columns cannot be interchanged without changing the meaning or use of the relation.

Answer: FALSE

Each row of a relation corresponds to a record that contains data values for an entity.

Each row of a relation corresponds to a record that contains data values for an entity.

Answer: TRUE

Object-oriented database models are the most frequently used database technologies for new information systems development.

Object-oriented database models are the most frequently used database technologies for new information systems development.

Answer: FALSE

File and database design occurs in two steps.

File and database design occurs in two steps.

Answer: TRUE

The index file organization:

The index file organization:

A) provides very fast random retrieval on the primary key
B) provides slow random retrieval on the primary key
C) provides moderately fast random retrieval on the primary key
D) does not provide random retrieval on the primary key



Answer: C