MIS 311 Exam 2 Review Questions

When all multivalued attributes have been removed from a relation, it is said to be in: ________ A) first normal form. B) second normal form. C) Boyce-Codd normal form. D) third normal form.

A) first normal form.

A form of database specification which maps conceptual requirements is called: ________ A) logical specifications. B) response specifications. C) security specifications. D) physical specifications.

A) logical specifications.

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. A) Business rule constraint B) Data integrity C) Business integrity D) Data structure

B) Data integrity

________ database specification indicates all the parameters for data storage that are then input to database implementation. A) Logical B) Physical C) Schematic D) Conceptual

B) Physical

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? A) First B) Second C) Third D) Fourth

B) Second

In the SQL language, the ________ statement is used to make table definitions. A) create session B) create table C) create index D) select

B) create table

When a regular entity type contains a multivalued attribute, one must: ________ A) create a single relation with multiple lines for each instance of the multivalued attribute. B) create two new relations, one containing the multivalued attribute. C) create two new relations, both containing the multivalued attribute. D) delete the relation and start over.

B) create two new relations, one containing the multivalued attribute.

The ________ states that no primary key attribute may be null. A) referential integrity constraint B) entity integrity rule C) partial specialization rule D) range domain rule

B) entity integrity rule

The normal form which deals with multivalued dependencies is called: ________ A) fifth normal form. B) fourth normal form. C) Boyce-Codd normal form. D) sixth normal form.

B) fourth normal form.

Data is represented in the form of: ________ A) data trees. B) tables. C) data notes. D) chairs.

B) tables.

A candidate key must satisfy all of the following conditions EXCEPT: ________ A) the key must uniquely identify the row. B) the key must indicate the row's position in the table. C) the key must be nonredundant. D) each nonkey attribute is functionally dependent upon it.

B) the key must indicate the row's position in the table.

A nonkey attribute is also called a(n): ________ A) column. B) unimportant datum. C) descriptor. D) address.

C) descriptor.

A primary key whose value is unique across all relations is called a(n): ________ A) global primary key. B) inter-table primary key. C) enterprise key. D) foreign global key

C) enterprise key.

A constraint between two attributes is called a(n): ________ A) functional relation. B) attribute dependency. C) functional dependency. D) functional relation constraint.

C) functional dependency.

All of the following are the main goals of normalization EXCEPT: ________ A) minimize data redundancy. B) simplify the enforcement of referential integrity. C) maximize storage space. D) make it easier to maintain data.

C) maximize storage space.

An attribute (or attributes) that uniquely identifies each row in a relation is called a: ________ A) column. B) foreign field. C) primary key. D) duplicate key.

C) primary key.

A two-dimensional table of data sometimes is called a: ________ A) group. B) set. C) declaration. D) relation.

D) relation.