Database Systems - CH 6 MC

21. From a structural point of view, 3NF is better than _____. a. 2NF b. 3NF c. 5NF d. 6NF

ANSWER: a

23. From a structural point of view, 2NF is better than _____. a. 1NF b. 3NF c. 4NF d. BCNF

ANSWER: a

25. Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. a. determines b. derives from c. controls d. owns

ANSWER: a

36. Improving _____ leads to more flexible queries. a. atomicity b. normalization c. denormalization d. derived attribute

ANSWER: a

28. 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 _____. a. 1NF b. 2NF c. 3NF d. 4NF

ANSWER: a

40. From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices. a. derived b. atomic c. granular d. historical

ANSWER: a

45. In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other. a. multivalued dependency b. transitive dependency c. partial dependency d. functional dependency

ANSWER: a

22. 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. a. two b. three c. four d. five

ANSWER: b

32. In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies. a. Chen b. dependency c. functionality d. ER

ANSWER: b

33. Dependencies based on only a part of a composite primary key are known as _____ dependencies. a. primary b. partial c. incomplete d. composite

ANSWER: b

37. An atomic attribute _____. a. cannot exist in a relational table b. cannot be further subdivided c. displays multiplicity d. is always chosen to be a foreign key

ANSWER: b

39. Granularity refers to _____. a. the size of a table b. the level of detail represented by the values in a table's row c. the number of attributes represented in a table d. the number of rows in a table

ANSWER: b

41. In a real-world environment, we must strike a balance between design integrity and _____. a. robustness b. flexibility c. uniqueness d. ease of use

ANSWER: b

43. BCNF can be violated only if the table contains more than one _____ key. a. primary b. candidate c. foreign d. secondary

ANSWER: b

44. When a table contains only one candidate key, _____ are considered to be equivalent. a. the 1NF and the 2NF b. the 3NF and the BCNF c. the 4NF and the 3NF d. the BCNF and the DKNF

ANSWER: b

49. Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment. a. 1NF b. 2NF c. 3NF d. 4NF

ANSWER: b

50. _____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely. a. Normalized b. Data warehouse c. Temporary d. Report

ANSWER: b

24. An attribute that is part of a key is known as a(n) _____ attribute. a. important b. nonprime c. prime d. entity

ANSWER: c

30. 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. a. partial dependency b. transitive dependency c. repeating group d. primary key

ANSWER: c

35. A table that is in 2NF and contains no transitive dependencies is said to be in _____. a. 1NF b. 2NF c. 3NF d. 4NF

ANSWER: c

42. To generate a surrogate key, Microsoft Access uses a(n) _____ data type. a. character b. sequence c. AutoNumber d. identity

ANSWER: c

47. A table is in 4NF if it is in 3NF, and _____. a. all attributes must be dependent on the primary key and must be dependent on each other b. all attributes are unrelated c. it has no multivalued dependencies d. no column contains the same values

ANSWER: c

26. Some very specialized applications may require normalization beyond the _____. a. 1NF b. 2NF c. 3NF d. 4NF

ANSWER: d

27. Of the following normal forms, _____ is mostly of theoretical interest. a. 1NF b. 3NF c. BCNF d. DKNF

ANSWER: d

29. 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. a. partial dependency b. repeating group c. atomic attribute d. transitive dependency

ANSWER: d

31. A relational table must not contain a(n) _____. a. entity b. attribute c. relationship d. repeating group

ANSWER: d

34. If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute. a. Boyce-Codd normal forms b. redundancies c. time-variances d. partial dependencies

ANSWER: d

38. The most likely data type for a surrogate key is _____. a. character b. date c. logical d. numeric

ANSWER: d

46. 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 _____. a. 1NF b. 2NF c. 3NF d. 4NF

ANSWER: d

48. An example of denormalization is using a _____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows. a. transitive b. 3NF c. component d. temporary

ANSWER: d