Database & Design Ch.1-6 Midterm Review

One advantage of a database system over previous data management approaches is that the database system is considerably less complex.

• True

• False

_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

• Data ubiquity

• Data integrity

• Data anomaly

• Data quality

Corporations use only structured data.

• True

• False

Structure is based on the type of processing to be performed on the data.

• True

• False

A data warehouse can store data derived from many sources.

• True

• False

MySQL is an example of the _____.

• relational data model

• XML data model

• hierarchical model

• file system data model

The _____ relationship should be rare in any relational database design.

• 1:M

• 1:1

• M:N

• M:1

A _____ is a primary key created by a database designer to simplify the identification of entity instances. 

• surrogate key

• composite key

• compound key

• natural key

The purpose of an entity _____ is to simplify an entity-relationship diagram (ERD) and thus enhance its readability.

• interface

• cluster

•  

  constraint

• discriminator

Nonoverlapping subtypes are subtypes that contain a(n) _____ subset of the supertype entity set.

• unique

• nonunique

• subtypes

• entity