Question 1

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

Accepted Answer

A table in third normal form conforms to...

Question 2

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.E) A) and D)
F) B) and C) B

Question 3

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 4

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

Accepted Answer

A) True 
 B)False  False

Question 5

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 queryE) C) and D)
F) A) and B)

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.E) C) and D)
F) All of the above

Question 7

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 8

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

Accepted Answer

A)  1NF
B)  2NF
C)  3NF
D)  4NFE) B) and C)
F) A) and B)

Question 9

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 dependencyE) All of the above
F) C) and D)

Question 10

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 dataE) None of the above
F) A) and B)

Question 11

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 queriesE) All of the above
F) B) and C)

Question 12

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 relationE) A) and D)
F) A) and C)

Question 13

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 valueE) None of the above
F) A) and C)

Question 14

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 valuesE) C) and D)
F) B) and C)

Question 15

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 packageE) B) and D)
F) A) and B)

Question 16

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)  ClassPriceE) All of the above
F) A) and B)

Question 17

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 keysE) A) and B)
F) B) and D)

Question 18

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.E) A) and B)
F) A) and C)

Question 19

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 20

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.E) A) and D)
F) All of the above

Exam 5: Database Design: Normalization

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

Correct AnswerverifiedA table in third normal form conforms to...View AnswerShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedA table is in first normal form if it do...View AnswerShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is an algorithm?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a nonkey column?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a major goal of normalization?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Describe the purpose of the normalization process.

Correct AnswerverifiedThe 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.

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
A table in third normal form conforms to...
View Answer

Correct Answer
verified
B

Correct Answer
verified
A table is in first normal form if it do...
View Answer

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
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.

Correct Answer
verified