Question 1 (3 points) What is the primary purpose of normalization? Select the best answer: To reduce the number of resulting indexes To reduce the number of resulting tables To handle a larger number of concurrent query requests To minimize data redundancy Question 2 (3 points) Which of the following is in the list of the seven valid normal forms? Check only those that apply: 1NF DKNF NF-X 7NF 3NF Question 3 (3 points) Each successive level of normal form assumes that the design is already in the previous normal form. True False Question 4 (3 points) Fourth normal form(4NF) is used: To eliminate transitive dependencies In most production systems To eliminate multiple multivalued dependencies from a table To ensure that every constraint is dependent only on the key constraints and domain constraints Question 5 (3 points) The highest levels of normalizations (like DKNF and 6NF): Are used most commonly in industry Generally result in a small number of tables with many columns Do not adequately reduce data redundancy Are largely an academic exercise and seldom used in practice Question 6 (3 points) For a table to be in first normal form (1NF) It cannot contain abnormal data Its columns cannot contain repeating values (but rows can) Its rows cannot contain repeating values (but columns can) All non-key columns must be dependent on the whole key Question 7 (3 points) Second normal form (2NF): Requires all non-key columns to be dependent on only part of the primary key Applies only to tables with a composite primary key Can be achieved by combining two or more tables into one Applies only to tables with a single-column primary key Question 8 (3 points) Third normal form(3NF): Requires that all non-key columns be dependent on only the primary key Results in increased data redundancy Requires the table to contain derived data Is implemented by combining multiple tables into one Question 9 (3 points) Consider the COURSE table below (its composite primary key columns are in red) DEPTCRSE NO DESCRIPTION HOURS CIS CIS ENG Values in its DEPTNAME column are derived from those in DEPT so the table is not in third normal form. Which transformation below correctly implements 3NF? DEPTNAME 275 Introductory SQL 276 Advanced SQL 100 Introductory Writin 4Computer Information Systems 4Computer Information Systems 4English Two tables: DEPT and CRSE DEPTDESCRIPTION HOURS CIS Introductory SQL CIS Advanced SQL ENG Introductory Writin RSE NO DESC! 275 Introduct 276 Advance 100Introduct DEPTNAME 4Computer Information Systems 4Computer Information Systems 4English Two tables: COURSE and DEPT: DEPT CRSE NO DESCRIPTION HOURS DEP CIS CIS ENG DEPTNAME 275 Introductory SQL 276Advanced SQL 100 Introductory Writin 4 CISComputer Information Systems 4 ENG English 4 Two tables: COURSE and DEPTNAME: DEPTCRSE NO DESCRIPTION HOURSCRSE NO CIS CIS ENG DEPTNAME 275 Introductory SQL 276 Advanced SQL 100 Introductory Writin 4 4 4 275 Computer Information Systen 276 Computer Information Systen 100 English Two tables: CIS and ENG: DEPTCRSE NOI DESCRIPTION HOURS CIS CIS DEPTNAME DEPTCRS 275 Introductory SQL 276Advanced SQL 4Computer Information Systems ENG 4 Computer Information Systems Question 10 (3 points) Denormalization generally results in A design in fifth normal form (5NF) Smaller tables, increased performance Larger tables, increased redundancy, reduced performance Corruption of data
