Topic 4

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

• logical designs.

• response designs.

• security design.

• physical design.

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

In the figure below, the primary key for 'Order Line' is which type of key?

• Composite

• Foreign

• Standard

• Grouped