CIS 111 All Assignments CIS 111 All Assignments | Page 8

• Question 30 If an entity can exist apart from one or more related entities, it is said to be
____-independent.
• Question 31 A ____ should be a derived attribute.
• Question 32 A relationship is an association between ____.
• Question 33 Before converting a table into 3NF, it is imperative the table already be in ____.
• Question 34 From a structural point of view, 2NF is better than ____.
• Question 35 For most business transactional databases, we should normalize relations into
____.
• Question 36 ____ databases reflect the ever-growing demand for greater scope and depth in
the data on which decision support systems increasingly rely.
• Question 37 A table that displays data redundancies yields ____.
• Question 38 A ____ exists when there are functional dependencies such that Y is functionally
dependent on X and Z is functionally dependent on Y, and X is the primary key.
• Question 39 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 40 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.
Set 4
•
Question 1 ____ provide(s) a description of the data characteristics and the set of
relationships that link the data found within the database.
•
Question 2 ____ data exist in a format that does not lend itself to processing that yields
information.