The Relational Model: Relational Schema, Keys and Relational Operators

This quiz contains multiple-choice problems dealing with the concepts of the relational model, such as relational schema, keys and relational query operators.

Start Quiz

For each attribute of a relation, there is a set of permitted values, called the __ of that attribute.

Domain

Relation

Set

Schema

An attribute in a relation is a foreign key if a relation uses its __ key as an attribute.

Candidate

Sub

Super

Primary

Which one of the following cannot be taken as a primary key?

Dept_id

Street

The __ is where the primary key of one relation is used as a common attribute in another relation.

Referential relation

Referencing relation

Referenced relation

Referred relation

A __ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Primary

Referencing

Specific

Referential

The term __ is used to refer to a row.

Attribute

Tuple

Field

Instance

The tuples of the relations can be of __ order.

Any

Same

Sorted

Constant

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

DB2

IDMS

dBase-II

R:base

Which of the following is not a fundamental element of an enterprise-class database system?

COBOL programs

Database applications

DBMS

Users

Which of the following products implemented the CODASYL DBTG model?

IDMS

DB2

dBase-II

R:base

Database __ is the logical design of the database, and the database __ is a snapshot of the data in the database at a given instant in time.

Instance, Schema

Relation, Schema

Relation, Domain

Schema, Instance

Business users interact directly with database applications in an enterprise-class database system, directly accessing the database data. True or false?

True

False

A relational database consists of a collection of

Keys

Fields

Records

Tables

An online commercial site such as Amazon.com is an example of

A single-user database application

A multi-user database application

An e-commerce database application

A data mining database application