Question 1

A table with no repeating groups in any attribute and atomic values in each column is, at a minimum, in what normal form?

Accepted Answer

A) third normal form 
B) first normal form 
C) second normal form 
D) The table is unnormalized. 
A) third normal form 
B) first normal form 
C) second normal form 
D) The table is unnormalized. B

Question 2

Functional dependence refers to how tables are related to each other in a database.

Accepted Answer

A) True 
 B)False  False

Question 3

Describe the purpose of the normalization process.

Accepted Answer

The normalization process is a series of progressive steps that enables you to identify and correct data redundancy and integrity problems that occur when data is stored in one large table.

Question 4

What helps separate atomic values from a single column if the values follow a pattern?

Accepted Answer

A) conversion anomaly 
B) Codd's 12 rules 
C) algorithm 
D) transitive dependency 
A) conversion anomaly 
B) Codd's 12 rules 
C) algorithm 
D) transitive dependency

Question 5

Data stored in a single list often creates redundant data when _____.

Accepted Answer

A) the list is not sorted 
B) the list contains multiple subjects or topics 
C) the list is used for looking up data 
D) the list contains atomic values 
A) the list is not sorted 
B) the list contains multiple subjects or topics 
C) the list is used for looking up data 
D) the list contains atomic values

Question 6

Which of the following is a benefit of having atomic values in each column of a table?

Accepted Answer

A) The data is easier to sort, find, and filter. 
B) Atomic values prevent deletion anomalies. 
C) The data is functionally independent. 
D) The data can be organized into repeating groups. 
A) The data is easier to sort, find, and filter. 
B) Atomic values prevent deletion anomalies. 
C) The data is functionally independent. 
D) The data can be organized into repeating groups.

Question 7

What is a major goal of normalization?

Accepted Answer

A) minimizing redundant data 
B) clarifying field names 
C) increasing functional independence 
D) selecting suitable primary keys 
A) minimizing redundant data 
B) clarifying field names 
C) increasing functional independence 
D) selecting suitable primary keys

Question 8

What is the difference between a table in first normal form and one in second normal form?

Accepted Answer

A table is in first normal form if it do

Question 9

What is the foreign key in the following table? Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice, InstructorNum)

Accepted Answer

A) ClassID 
B) ClassName 
C) InstructorNum 
D) ClassPrice 
A) ClassID 
B) ClassName 
C) InstructorNum 
D) ClassPrice

Question 10

Which of the following pairs has the clearest field name and atomic value?

Accepted Answer

A) DistanceInMiles, 20 
B) Length, 10 feet 
C) Time, 1.5 
D) Amount, 12 per package 
A) DistanceInMiles, 20 
B) Length, 10 feet 
C) Time, 1.5 
D) Amount, 12 per package

Question 11

What is a nonkey column?

Accepted Answer

A) a column that contains a null value 
B) a column that is not part of the foreign key 
C) a column that is not part of the primary key 
D) a column that does not contain an atomic value 
A) a column that contains a null value 
B) a column that is not part of the foreign key 
C) a column that is not part of the primary key 
D) a column that does not contain an atomic value

Question 12

What is an algorithm?

Accepted Answer

A) a piece of data that cannot be meaningfully divided 
B) a defined set of steps to solve a problem 
C) a characteristic or property of an entity 
D) a problem generated when entering, updating, and deleting data 
A) a piece of data that cannot be meaningfully divided 
B) a defined set of steps to solve a problem 
C) a characteristic or property of an entity 
D) a problem generated when entering, updating, and deleting data

Question 13

What is the problem with designing a database in which the last name of an employee functionally determines the employee's address?

Accepted Answer

A) This design has no problems. 
B) Two employees could be living at the same address. 
C) More than one employee could have the same last name. 
D) The address will automatically functionally determine the employee's last name. 
A) This design has no problems. 
B) Two employees could be living at the same address. 
C) More than one employee could have the same last name. 
D) The address will automatically functionally determine the employee's last name.

Question 14

The nonkey fields of a table should be functionally dependent on _____.

Accepted Answer

A) the foreign key field 
B) the primary key field 
C) at least one field in a related table 
D) an unnormalized relation 
A) the foreign key field 
B) the primary key field 
C) at least one field in a related table 
D) an unnormalized relation

Question 15

Which of the following is not a problem with duplicated data?

Accepted Answer

A) increased storage 
B) decreased performance 
C) inconsistencies in the data 
D) decreased time in running queries 
A) increased storage 
B) decreased performance 
C) inconsistencies in the data 
D) decreased time in running queries

Question 16

The normalization process is a series of steps built into most relational database management software products that will automatically restructure your database to resolve all design flaws.

Accepted Answer

A) True 
 B)False

Question 17

Define third normal form and give an example of a transitive dependency.

Accepted Answer

A table in third normal form conforms to

Question 18

What type of query should you create to populate new EmployeeFirst and EmployeeLast fields with atomic values from an EmployeeName field?

Accepted Answer

A) select query 
B) update query 
C) concatenation query 
D) atomic query 
A) select query 
B) update query 
C) concatenation query 
D) atomic query

Question 19

How do you free data from the problems associated with insertion, update, and deletion anomalies?

Accepted Answer

A) Apply algorithms to identify the anomalies. 
B) Remove the functional dependencies from the data. 
C) Normalize the data by converting a single list into multiple tables. 
D) Identify atomic values in the data. 
A) Apply algorithms to identify the anomalies. 
B) Remove the functional dependencies from the data. 
C) Normalize the data by converting a single list into multiple tables. 
D) Identify atomic values in the data.

Question 20

Which normal form has an additional condition that excludes transitive dependencies?

Accepted Answer

A) 1NF 
B) 2NF 
C) 3NF 
D) 4NF 
A) 1NF 
B) 2NF 
C) 3NF 
D) 4NF

A table with no repeating groups in any attribute and atomic values in each column is, at a minimum, in what normal form?

Functional dependence refers to how tables are related to each other in a database.

Describe the purpose of the normalization process.

What helps separate atomic values from a single column if the values follow a pattern?

Data stored in a single list often creates redundant data when _____.

Which of the following is a benefit of having atomic values in each column of a table?

What is a major goal of normalization?

What is the difference between a table in first normal form and one in second normal form?

What is the foreign key in the following table? Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice, InstructorNum)

Which of the following pairs has the clearest field name and atomic value?

What is a nonkey column?

What is an algorithm?

What is the problem with designing a database in which the last name of an employee functionally determines the employee's address?

The nonkey fields of a table should be functionally dependent on _____.

Which of the following is not a problem with duplicated data?

The normalization process is a series of steps built into most relational database management software products that will automatically restructure your database to resolve all design flaws.

Define third normal form and give an example of a transitive dependency.

What type of query should you create to populate new EmployeeFirst and EmployeeLast fields with atomic values from an EmployeeName field?

How do you free data from the problems associated with insertion, update, and deletion anomalies?

Which normal form has an additional condition that excludes transitive dependencies?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 5: Database Design: Normalization

A table with no repeating groups in any attribute and atomic values in each column is, at a minimum, in what normal form?

Functional dependence refers to how tables are related to each other in a database.

Describe the purpose of the normalization process.

What helps separate atomic values from a single column if the values follow a pattern?

Data stored in a single list often creates redundant data when _____.

Which of the following is a benefit of having atomic values in each column of a table?

What is a major goal of normalization?

What is the difference between a table in first normal form and one in second normal form?

What is the foreign key in the following table? Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice, InstructorNum)

Which of the following pairs has the clearest field name and atomic value?

What is a nonkey column?

What is an algorithm?

What is the problem with designing a database in which the last name of an employee functionally determines the employee's address?

The nonkey fields of a table should be functionally dependent on _____.

Which of the following is not a problem with duplicated data?

The normalization process is a series of steps built into most relational database management software products that will automatically restructure your database to resolve all design flaws.

Define third normal form and give an example of a transitive dependency.

What type of query should you create to populate new EmployeeFirst and EmployeeLast fields with atomic values from an EmployeeName field?

How do you free data from the problems associated with insertion, update, and deletion anomalies?

Which normal form has an additional condition that excludes transitive dependencies?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters