ISM 4212 Quiz

Which of the following are anomalies that can be caused by redundancies in tables? All of the above Modification Insertion Deletion

All of the above

Which of the following are properties of relations? There are no multi-valued attributes Each attribute has a unique name All of the above No two rows are identical

All of the above

The idea that subtype entities inherit all of the attributes of the supertype entity is called: Subtype instance. Attribute inheritance. Supertype/subtype cluster Attribute generalization.

Attribute inheritance.

A relation that contains no multi-valued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? Second Third Fourth First

Second

A subtype is a subgrouping of the entities in an entity type that has attributes distinct form those in other subgroupings. True False

True

A primary key that consists of more than one attribute is called a: multi-valued key foreign key composite key cardinal key

composite 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 attribute foreign key

foreign key

A constraint between two attributes is called a(n): referential constraint functional dependency attribute dependency functional relation constraint

functional dependency

The process of defining a more general entity type from a set of more specialized entity types is know as: generalization specialization allotment specification

generalization

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency. transitive key dependency cross key partial functional merged relation

partial functional

An attribute (or attributes) that uniquely identifies each row in a relation is called a: column record duplicate key primary key

primary key

A rule that states that each foreign key value must match a primary key value in the other relation is called the: key match constraint foreign/primary key match rule referential integrity constraint entity key group rule

referential integrity constraint

The process of defining one or more subtypes of the general entity type is know as: generalization allotment specification specialization

specialization

A functional dependency between two or more nonkey attributes is called a: partial nonkey dependency referential dependency partial entity dependency transitive dependency

transitive dependency

A supertype is a generic entity type that has a relationship with one or more subtypes. True False

true