Database Management Extra 6

Question 1

The property of a relational table that guarantees each entity has a unique value in a primary key and that the key has no null values.

Answer 1

Entity Integrity

Question 2

Special codes implemented by designers to trigger a required response, alert end users to specified conditions, or encode values. ??? may be used to prevent nulls by bringing attention to the absence of a value in a table.

Answer 2

Flags

Question 3

An attribute or attributes in one table whose values must match the primary key in another table or whose values must be null.

Answer 3

Foreign Key (FK)

Question 4

A condition in which an attribute is functionally dependent on a composite key but not on any subset of the key.

Answer 4

Full Functional Dependence

Question 5

Within a relation R, an attribute B is functionally dependent on an attribute A if and only if a given value of attribute A determines exactly one value of attribute B. The relationship “B is dependent on A” is equivalent to “A determines B,” and is written as A->B.

Answer 5

Functional Dependence

Question 6

An ordered array of key values and row ID values (pointers). ??? are generally used to speed up and facilitate data retrieval. Also known as an ??? key.

Answer 6

Index

Question 7

One or more attributes that determine other attributes.

*** Key Attribute = The attributes that form a primary key.

Answer 7

Key

Question 8

In the relational model, a table that implements an M:M relationship.

Answer 8

Linking Table

Question 9

Used extensively in mathematics to provide a framework in which an assertion (statement of fact) can be verified as either true or false.

Answer 9

Predicate Logic

Question 10

In the relational model, an identifier composed of one or more attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier.

Answer 10

Primary Key (PK)