Chapter 6 (Multiple Choice CIS 3365)

1. Normalization works through a series of stages called normal forms. Typically ____ stages are processed.

2. 1NF, 2NF, and 3NF are ____.

3. From a structural point of view, 2NF is better than ____.

4.____ yields better performance.

5. A table that displays data redundancies yields ____.

6. Data redundancy produces ____.

7. Converting a ____ is not an example of denormalization.

8. Some very specialized applications may require normalization beyond the ____.

9. Of the following normal forms,____, is mostly of theoretical interest.

10.____ is not a valid normal form.

11. A relation is not in 1NF if ____.

12. A(n) ____ should not be placed in a relational table.

13. 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.

14. Dependencies based on only a part of a composite primary key are called ____ dependencies.

15. An attribute that is part of a key is known as a(n) ____ attribute.

16. Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS),of the following,____, is a partial dependency.

17. In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies

18. 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 ____.

17. A table that is in 1NF and includes no partial dependencies is said to be in ____.

18. If you have three different transitive dependencies, ____ different determinant(s) exist.

19. Before converting a table into 3NF, it is imperative the table already be in ____.

20. 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.

21. A table that is in 2NF and contains no transitive dependencies is said to be in ____.

22. According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.

23. Improving ____ leads to more flexible queries.

24. An atomic attribute ____.

25. The most likely data type for a surrogate key is ____

26. Granularity refers to ____.

27. From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.

28. In a real-world environment, we must strike a balance between design integrity and ____.

29. For most business transactional databases, we should normalize relations into ____.

30. To generate a surrogate key, Microsoft Access uses a(n) ____ data type.

31. A table where every determinant is a candidate key is said to be in ____.

32. BCNF can be violated only if the table contains more than one ____ key.

33. Most designers consider the BCNF as a special case of the ____

34. A table is in 4NF if ____.

35. A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.

36. When designing a database, you should ____.

37. Normalization represents a micro view of the ____ within the ERD.

38. 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 is stored in the table as rows.

39. The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.

40.____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.