Logical Database Design and the Relational Model

_______ 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