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