CIS 111 All Assignments CIS 111 All Assignments | Seite 3

•
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 36 The most likely data type for a surrogate key is ____.
•
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.