The Relational Database Quiz - Module 3

The _____ relationship should be rare in any relational database design.

1:1

Date attributes contain calendar dates stored in a special format known as the _____ date format.

Julian

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

M:N

_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems.

Outer joins

_____ returns only the attributes requested, in the order in which they are requested.

PROJECT

_____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.

Predicate

To be considered minimally relational, the DBMS must support the key relational operators _____, PROJECT, and JOIN.

SELECT

_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

SELECT

Another name for a composite entity is a(n) _____ entity.

bridge

A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.

candidate

Each table _____ represents an attribute.

column

The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.

entity

In a database context, the word _____ indicates the use of the same attribute name to label different attributes.

homonym

A(n) _____ is an orderly arrangement used to logically access rows in a table.

index

Referential _____ dictates that the foreign key must contain values that match the primary key in the related table or must contain null.

integrity

In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.

keys

According to Codd's _____ rule of relational databases, if the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database.

nonsubversion

A _____ key is defined as a key that is used strictly for data retrieval purposes.

secondary

In a database context, a(n) _____ indicates the use of different names to describe the same attribute.

synonym

The _____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

system catalog