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 database model
D) hybrid database model



Answer: C

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) a dashed underline
D) italics



Answer: 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, and updated
C) the expectations for response time and data integrity
D) all of the above



Answer: D

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 into one consolidated logical database model.
B) Compare the consolidated logical database design with the translated E-R model and produce, through view integration, one final logical database design for the application.
C) Model how data flow through an information system, the relationships among the data flows, and how data come to be stored at specific locations.
D) Translate the conceptual E-R data model for the application into normalized data requirements.



Answer: C

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) object-oriented database model



Answer: A

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

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

Answer: FALSE

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

Answer: TRUE

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

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

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

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