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

   
 

Transcribed Image Text:

1. Normalization works through a series of stages called normal forms. Typically processed. a. 2 ь. 3 4 d. 5 stages are с. 2. Some very specialized applications may require normalization beyond the a. INF b. 2NF c. 3NF d. 4NF 3 A table is in the 4NF if a. all attributes must be dependent on the primary key, and must be dependent on each other b. all attributes are unrelated c. no row can contain two or more multivalued facts about an entity. d. no column contains the same values 5. A table that is in 1NF and includes no partial dependencies only is said to be in а. 1NF b. 2NF с. 3NF d. 4NF 5. A table where every determinant is a candidate key is said to be in а. ВСNF b. 2NF c. 3NF d. 4NF 6. The model views the data as part of a table or collection of tables in which all key values must be identified. a. relational b. object-oriented c. conceptual d. external 7. Normalization works through a series of normal a. schemas b. entities c. databases d. forms 8. yields better performance. a. Denormalization b. Normalization c. Atomization d. Compression 9. An attribute that is part of a key is known as a(n) a. important b. nonprime c. prime d. entity attribute. 26. In a real-world environment, we must strike a balance between design integrity and a. robustness b. flexibility c. uniqueness d. ease of use 10. When designing a database, you should a. make sure entities are in normal form before table structures are created b. create table structures then normalize the database c. only normalize the database when performance problems occur d. consider more important issues such as performance before nomalizing 11. Which of the following is not a valid normal form? a. 1NF b. BCNF c. 3NF d. MVNF 12. Given the table EMP_PROJ (PROJ NUM, EMP NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG HOURS, HOURS), which of the following is a partial dependency? a. PROJ_NUM --> PROJ_NAME b. JOB_CLASS -> CHG HOUR c. PROJ_NUM, EMP_NUM --> HOURS d. PROJ NUM, EMP_NUM --> CHG HOURS 13. A relation is not in INF if a. it has multiple candidate keys b. all of the key attributes are defined c. there are repeating groups in the table d. all attributes are dependent on the primary key 2. 14. Granularity refers to: a. the size of a table b. the level of detail represented by the values stored in a table's row c. the number of attributes in a table d. the number of rows in a table 15. All of the following are required for a table to be in BCNF except: a. the table must be in 1NF b. the table must be in 3NF c. the table must be in 4NF d. every determinant in the table must be a candidate key Short Answer questions 1. Explain the BCNF. How is it related to other normal forms? 2. Explain normalization and its different forms. 3. Describe the dependency diagram and explain its purpose. PROBLEM: 1. Given the dependency diagram shown in the following Figure 1, answer items la: FIGURE 1: Dependency Diagram C2 C4 C5 a. Identify and discuss each of the indicated dependencies. 2. Consider the database VIDEOS that you created in week 4. Check your tables for 3NF. If they are not in 3NF, modify your database so that your tables are devoid of partial and transitive dependencies. 3 1. Normalization works through a series of stages called normal forms. Typically processed. a. 2 ь. 3 4 d. 5 stages are с. 2. Some very specialized applications may require normalization beyond the a. INF b. 2NF c. 3NF d. 4NF 3 A table is in the 4NF if a. all attributes must be dependent on the primary key, and must be dependent on each other b. all attributes are unrelated c. no row can contain two or more multivalued facts about an entity. d. no column contains the same values 5. A table that is in 1NF and includes no partial dependencies only is said to be in а. 1NF b. 2NF с. 3NF d. 4NF 5. A table where every determinant is a candidate key is said to be in а. ВСNF b. 2NF c. 3NF d. 4NF 6. The model views the data as part of a table or collection of tables in which all key values must be identified. a. relational b. object-oriented c. conceptual d. external 7. Normalization works through a series of normal a. schemas b. entities c. databases d. forms 8. yields better performance. a. Denormalization b. Normalization c. Atomization d. Compression 9. An attribute that is part of a key is known as a(n) a. important b. nonprime c. prime d. entity attribute. 26. In a real-world environment, we must strike a balance between design integrity and a. robustness b. flexibility c. uniqueness d. ease of use 10. When designing a database, you should a. make sure entities are in normal form before table structures are created b. create table structures then normalize the database c. only normalize the database when performance problems occur d. consider more important issues such as performance before nomalizing 11. Which of the following is not a valid normal form? a. 1NF b. BCNF c. 3NF d. MVNF 12. Given the table EMP_PROJ (PROJ NUM, EMP NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG HOURS, HOURS), which of the following is a partial dependency? a. PROJ_NUM --> PROJ_NAME b. JOB_CLASS -> CHG HOUR c. PROJ_NUM, EMP_NUM --> HOURS d. PROJ NUM, EMP_NUM --> CHG HOURS 13. A relation is not in INF if a. it has multiple candidate keys b. all of the key attributes are defined c. there are repeating groups in the table d. all attributes are dependent on the primary key 2. 14. Granularity refers to: a. the size of a table b. the level of detail represented by the values stored in a table's row c. the number of attributes in a table d. the number of rows in a table 15. All of the following are required for a table to be in BCNF except: a. the table must be in 1NF b. the table must be in 3NF c. the table must be in 4NF d. every determinant in the table must be a candidate key Short Answer questions 1. Explain the BCNF. How is it related to other normal forms? 2. Explain normalization and its different forms. 3. Describe the dependency diagram and explain its purpose. PROBLEM: 1. Given the dependency diagram shown in the following Figure 1, answer items la: FIGURE 1: Dependency Diagram C2 C4 C5 a. Identify and discuss each of the indicated dependencies. 2. Consider the database VIDEOS that you created in week 4. Check your tables for 3NF. If they are not in 3NF, modify your database so that your tables are devoid of partial and transitive dependencies. 3

Answer rating: 100% (QA)

Multiple Choice 1 b 3 1NF 2NF 3NF 2 d 4NF 3 c No row can contain two or more multivalued facts about ... View the full answer