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...

Multiple key retrieval is possible with the hashed file organization.

Multiple key retrieval is possible with the hashed file organization. Answer: FAL...

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: FAL...

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

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: TR...

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: TR...

Denormalization reduces the chance of errors introduced by normalizing relations.

Denormalization reduces the chance of errors introduced by normalizing relations. Answer: FAL...

Generally speaking, a physical table corresponds to a relation.

Generally speaking, a physical table corresponds to a relation. Answer: FAL...

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: FAL...

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: TR...

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: FAL...

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: TR...

An attribute can be functionally dependent on more than attribute.

An attribute can be functionally dependent on more than attribute. Answer: TR...

Normalization is based on an analysis of weak entities.

Normalization is based on an analysis of weak entities. Answer: FAL...

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: FAL...

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: FAL...

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: TR...

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: FAL...

File and database design occurs in two steps.

File and database design occurs in two steps. Answer: TR...

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...

A field of data that can be used to locate a related field or row of data best describes:

A field of data that can be used to locate a related field or row of data best describes: A) pointer B) marker C) field locator D) reference locator Answer:...

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes: A) normalization B)...

A named set of rows and columns that specifies the fields in each row of the table best describes:

A named set of rows and columns that specifies the fields in each row of the table best describes: A) relation B) data structure C) entity type D)...

A single name that is used for two or more different attributes best defines:

A single name that is used for two or more different attributes best defines: A) homonym B) synonym C) transitive dependency D) alias Answer:...

Merging relations is also referred to as:

Merging relations is also referred to as: A) view integration B) view consolidation C) encompassing D) normalizing Answer:...

For a unary M:N relationship:

For a unary M:N relationship: A) the entity type is modeled as one relation; using as its primary key a composite key, a separate relation is created...

A many-to-many relationship that associates certain items with their component items is called a:

A many-to-many relationship that associates certain items with their component items is called a: A) binary structure B) bill-of-materials structure C)...

If a relationship exists among three or more entities, then:

If a relationship exists among three or more entities, then: A) recursive relationships must be established through the use of recursive foreign...

For a binary many-to-many relationship existing between entity types A and B:

For a binary many-to-many relationship existing between entity types A and B: A) a separate relation C is created; the primary key of relation C...

For a binary one-to-one relationship between two entities A and B, the relationship is represented by:

For a binary one-to-one relationship between two entities A and B, the relationship is represented by: A) adding the primary key of A as a foreign...

An entity whose primary key depends on the primary key of another entity is called a:

An entity whose primary key depends on the primary key of another entity is called a: A) referential entity B) candidate entity C) transitive entity D)...

When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes:

When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes: A) the primary key of the corresponding relation B)...

Which of the following statements is true regarding normalization?

Which of the following statements is true regarding normalization? A) Normalization is a top-down process. B) Normalization produces a set of well-structured...

To convert a relation to second normal form, you decompose the relation into new relations using the attributes, called:

To convert a relation to second normal form, you decompose the relation into new relations using the attributes, called: A) determinants B) foreign...

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is: A) first normal form B) second...

A particular relationship between two attributes best defines:

A particular relationship between two attributes best defines: A) context B) functional dependency C) normal form D) structure Answer:...

The process of converting complex data structures into simple, stable data structures is referred to as:

The process of converting complex data structures into simple, stable data structures is referred to as: A) normalization B) simplification C) structuring D)...

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued? A) Entries in cells...

Which of the following is not a true statement regarding a relation?

Which of the following is not a true statement regarding a relation? A) Each relation consists of a set of named columns and an arbitrary number...

A data model that represents data in the form of tables or relations is called a:

A data model that represents data in the form of tables or relations is called a: A) hierarchical database model B) network database model C) relational...

Using relational notation, an attribute of a relationship that is the primary key of another relation is indicated by:

Using relational notation, an attribute of a relationship that is the primary key of another relation is indicated by: A) an underline B) a circle C)...

During physical design, you consider:

During physical design, you consider: A) the definitions of each attribute B) the descriptions of where and when data are entered, retrieved, deleted,...

Which of the following is not a key step in logical database modeling and design?

Which of the following is not a key step in logical database modeling and design? A) Combine normalized data requirements from all user interfaces...

The most common style for a logical database model is the:

The most common style for a logical database model is the: A) relational database model B) hierarchical database model C) network database model D)...

The primary deliverable from logical database design is a conceptual model.

The primary deliverable from logical database design is a conceptual model. Answer: FAL...

A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored, retrieved, and updated rapidly.

A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored, retrieved, and...

During logical modeling, the normalized data requirements from all user interfaces are combined into one consolidated logical database model.

During logical modeling, the normalized data requirements from all user interfaces are combined into one consolidated logical database model. Answer:...

Generally speaking, logical and physical database design is performed in parallel with other systems design steps.

Generally speaking, logical and physical database design is performed in parallel with other systems design steps. Answer: TR...

The network model is the most common style for a logical database model.

The network model is the most common style for a logical database model. Answer: FAL...

One of the purposes of database design is to choose data storage technologies that will efficiently, accurately, and securely process database activities.

One of the purposes of database design is to choose data storage technologies that will efficiently, accurately, and securely process database activities. Answer:...