1.Normalization works through a series of stages called normal forms.
True
2. Normalization is a process that is used for changing attributes to entities.
False
3. In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.
True
4. Denormalization produces a lower normal form.
True
5. The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.
True
6. Relational models view data as part of a table or collection of tables in which all key values must be identified.
True
7. Repeating groups must be eliminated by ensuring that each row defines a single entity.
True
8. The main goal of normalization is to eliminate _____. .
data anomalies
9. Dependency diagrams are very helpful in getting a bird’s-eye view of all the relationships among a table’s attributes.
True
10. To eliminate repeating groups and convert a table into the first normal form (1NF), what can you change in a table to convert multivalued attributes into single-valued attributes? _____.
focus
11. All relational tables satisfy 1NF requirements.
True
12. In the context of partial dependencies, data redundancies occur because every row entry requires the duplication of data.
True
13. Since a partial dependency can exist only if a table’s primary key is composed of several attributes, and if a table in 1NF has a single-attribute primary key, then the table is automatically in _____.
2NF
14. If a table in 2NF exhibits a transitive dependency, what does the primary key rely on to functionally determine nonprime attributes?
other non-prime attributes
15. What type of data is stored at their lowest level of granularity.
atomic
16. If a table is in the third normal form (3NF) and is also considered to be in Boyce-Codd normal form, what functional dependencies are taken into account as determinants?
candidate keys
17. If a table is in fourth normal form, it is in third normal form and has no _____.
multivalued dependencies
18. Which term represents a micro view of the entities within the ERD.
Normalization
19. The combination of normalization and ER modeling yields a useful _____, whose entities can be translated into appropriate table structures.
ERD
20. Normalization purity is often difficult to sustain in the modern database environment due to which of the following?
they contain partial and/or transitive dependencies
21. 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.
three
22. From a structural point of view, 3NF is better than _____.
2NF
23. From a structural point of view, 2NF is better than _____.
1NF
24. Raw data in its original state that has data anomalies such as redundant or multivalued data is _____ data.
unnormalized
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.
determines
26. Some very specialized applications may require normalization beyond the _____.
4NF
27. Of the following normal forms, _____ is mostly of theoretical interest.
DKNF
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 _____.
1NF
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.
transitive dependency
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.
repeating group
31. A relational table must not contain a(n) _____.
repeating group
32. In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.
dependency
33. Mario wants to choose a dependency which is based on only a part of a composite primary key. Which dependency does Mario choose?
partial
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.
partial dependencies
35. Select one of the following table types which defines a table in 2NF that contains no transitive dependencies?
3NF
36. Improving _____ leads to more flexible queries.
atomicity
37. An atomic attribute _____.
cannot be further subdivided
38. The most likely data type for a surrogate key is _____.
numeric
39. Granularity refers to _____.
the level of detail represented by the values in a table’s row
40. When using a system functionality point of view, which attribute values can be calculated when they are needed to write reports or invoices?
derived
41. Which of the following traits should you balance with design integrity?
flexibility
42. How would Microsoft Access generate a surrogate key?
AutoNumber
43. Which of the following keys in a table would cause you to violate BCNF if used more than once?
candidate
44. When a table contains only one candidate key, _____ are considered to be equivalent.
the 3NF and the BCNF
45. Which type of dependency illustrates how one key determines multiple values of two other attributes and those attributes are independent of each other?
multivalued dependency
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 _____.
4NF
47. A table is in 4NF if it is in 3NF, and _____.
it has no multivalued dependencies
48. Which type of demoralized table holds report data when creating a tabular report in which the columns represent data that are stored in the table as rows?
temporary
49. Which of the following structures is used in a complex, multilevel, multisource data environment?
2NF
50. _____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Data warehouse
51. Which unnormalized attribute in your data structure could make your data management more difficult?
multivalued
52. In exchange for possible reductions in performance, what unwanted element does normalization reduce?
data redundancies
53. An unnormalized data structure includes entities that can have relations with many instances of another entity type, for instance, employees that can be assigned to multiple projects. How does this affect adding, updating, and deleting data?
Multiple rows need to be updated.
54. According to the data-modeling checklist, _____ is a process used to ensure an entity-relationship model minimizes data redundancy to ensure single-place updates.
normalization
55. According to a standard data-modeling checklist, the non-key entities in an entity-relationship (ER) data model must be fully dependent on _____.
the primary key
56. When using a data-modeling checklist to design a new database structure based on the business requirements of the end users, what is the minimum preferred normal form all entities should be in?
3NF
57. When using a data-modeling checklist to design a data structure, attribute names should:
use descriptive suffixes
58. What type of dependency is shown during normalization, if the conversion to the second normal form involves removing all attributes dependent on only a part of a composite primary key?
partial dependency
59. According to the ERD data-modeling checklist, all entities in a relational table represent a single set of distinguishable sets of _____.
entity instances
60. Because a partial dependency can exist only when a table’s primary key is composed of several attributes, a table whose _____ key consists of only a single attribute is automatically in 2NF once it is in 1NF.
primary
61. Any attribute whose value determines other values within a row is known as a(n) _____.
determinant
62. If an attribute cannot be further subdivided, which of the following attributes would it display?
atomicity
63. Which term would you use to refer to the level of detail represented by the values stored in a table’s row?
Granularity
64. When faced with changing granularity requirements, primary key selections might change which ultimately may require usage of which additional key?
surrogate
65. When the related table uses a composite primary key, it becomes difficult to create which key?
foreign
66. Which of the following tables contains no rows with two or more multivalued facts about an entity?
4NF
67. An ERD is created through which of the following processes?
iterative
68. In order for you to yield a useful ERD, you must combine ER modeling with which of the following entities?
normalization
69. Unnormalized tables yield no simple strategies for creating virtual tables known as _____.
views
70. According to the data-modeling checklist, _____ should be nouns that are familiar to business, should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity.
entity names
Other Links:
See other websites for quiz:
Check on QUIZLET