1.A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.
The correct answer is: 1NF
2.A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.
The correct answer is: 4NF
3.A relational table must not contain a(n) _____.
The correct answer is: repeating group
4.An entity cluster is formed by combining multiple interrelated entities into _____.
The correct answer is: a single abstract entity object
5.A total completeness constraint is represented by a _____.
The correct answer is: double horizontal line under a circle
6.A table that is in 2NF and contains no transitive dependencies is said to be in _____.
The correct answer is: 3NF
7.An atomic attribute _____.
The correct answer is: cannot be further subdivided
8.An attribute that is part of a key is known as a(n) _____ attribute.
The correct answer is: prime
9.A _____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
The correct answer is: natural
10.A table is in 4NF if it is in 3NF, and _____.
The correct answer is: it has no multivalued dependencies
11._____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
The correct answer is: Generalization
12.A(n)_____ is a generic entity type that is related to one or more entity subtypes.
The correct answer is: entity supertype
13.A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.
The correct answer is: many
14.A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
The correct answer is: subtype discriminator
15.A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.
The correct answer is: transitive dependency
16.A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.
The correct answer is: repeating group
17.A _____ is a primary key created by a database designer to simplify the identification of entity instances.
The correct answer is: surrogate key
18._____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
The correct answer is: Data warehouse
19.A partial completeness constraint is represented by _____.
The correct answer is: a single horizontal line under a circle
20.According to the “preferably single-attribute” characteristic of a primary key, the primary key:
The correct answer is: should have the minimum number of attributes possible.
Other Links:
See other websites for quiz:
Check on QUIZLET