• Question 30 An entity is said to be ____-dependent if it can exist in
the database only when it is associated with another related entity
occurrence.
• Question 31 A ____ entity has a primary key that is partially or
totally derived from the parent entity in the relationship.
• Question 32 The M:N relationship between STUDENT and CLASS
must be divided into two 1:M relationships through the use of the
ENROLL entity; the ENROLL entity is ____.
• Question 33 From a strictly database point of view, ____ attribute
values can be calculated when they are needed to write reports or
invoices.
• Question 34 A table that displays data redundancies yields ____.
• Question 35 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 ____.
• Question 37 ____ databases reflect the ever-growing demand for
greater scope and depth in the data on which decision support systems
increasingly rely.
• Question 38 A table that is in 1NF and includes no partial
dependencies is said to be in ____.
• Question 39 Normalization works through a series of stages called
normal forms. For most purposes in business database design, ____
stages are as high as you need to go in the normalization process.
• Question 40 1NF, 2NF, and 3NF are ____.
Set 2
Question 1 Correct ____ is used to reveal the meaning of data.
. Question 2 Correct A(n) ____ database is designed to support a
company’s day-to-day operations.
. Question 3 Correct ____ exists when different versions of the same
data appear in different places.
. Question 4 Correct A desktop database is a ____ database.