Database management quiz 3

If a relation's key has more than one column, we say the key is integrated

False

If a data value is null, then it is 0

False

The rule that says no key column value may be null is called referential integrity

False

A 3NF relation with no multi-valued dependencies is in

Fourth Normal Form

In the relational model, a column is called an attribute

True

In the relational model, a row in a table is called a tuple

True

In the relational model, a table is called

a relation

In the relational model a record is called

a tuple

In the relational model, a field is called

an attribute

A unique row identifier that has meaning in the world outside the computer system is called

an external key

An internally generated value that is unique to a row in a table is called

an object identifier

In the relational model, a possible unique row identifier is called a(n) _____ ____.

candidate key

If a relation's key has more than one column, we say the key is a(n) _____ key.

composite

The rule that says no key column value may be null is called

entity integrity

The normalization rule that every attribute value must be atomic is called _____ _____ _____.

first normal form

In the relational model, a column that connects a table to another table is called a(n) ______ _____.

foreign key

A normalization rule that says one column's value determines another column's value is called a(n) _______ ______.

functional dependency

If a data value is null, then it

may not apply

In standard relational notation, underlined column names identify the _____ _____ of the relation.

primary key

A foreign key that references its own table is called

recursive

The rule that says a foreign key must be null or have an actual key value is called

referential integrity

If a relation has multiple attributes for the key and only a portion of the key is a determinant of other attributes, then the relation violates _____ _____ _____. (words only)

second normal form

In standard relational notation, a comma-separated list of names identifies

the attributes

The column on the left side of a functional dependency is called

the determinant

If every attribute in a key of a relation is a determinant, then the relation conforms to _____ _____ _____. (words only)

third normal form