Logical Database Design Quiz

________ database specification indicates all the parameters for data storage that are then input to database implementation.

• Logical

• Physical

• Schematic

• Conceptual

A form of database specification which maps conceptual requirements is called:

• logical specifications.

• response specifications.

• security specifications.

• physical specifications.

Data is represented in the form of:

• data trees.

• tables.

• data notes.

• chairs.

A two-dimensional table of data sometimes is called a:

• group.

• set.

• declaration.

• relation.

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

• Business rule constraint

• Data integrity

• Business integrity

• Data structure

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

• column.

• foreign field.

• primary key.

• duplicate key.

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

• link attribute.

• link key.

• foreign key.

• foreign attribute.

A primary key whose value is unique across all relations is called a(n):

• global primary key.

• inter-table primary key.

• enterprise key.

• foreign global key.

A primary key that consists of more than one attribute is called a:

• foreign key.

• composite key.

• multivalued key.

• cardinal key.

In the SQL language, the ________ statement is used to make table definitions.

• create session

• create table

• create index

• select