BUAN 6320 - Exam 2 Review Questions with Correct
Answers
What is normalization? Correct Answer-Evaluating and correcting table
structures to minimize data redundancies
What are the benefits of normalization? Correct Answer-• Reduces data
anomalies
• Assigns attributes to tables based on determination
What are the normal forms? Correct Answer-• First normal form (1NF)
• Second normal form (2NF)
• Third normal form (3NF)
What makes up the structural point of view of normal forms? Correct
Answer-• Higher normal forms are better than lower normal forms
• Properly designed 3NF structures meet the requirement of fourth
normal form (4NF)
What is denormalization? Correct Answer-Produces a lower normal
form
What does denormalization result in? Correct Answer-• Results in
increased performance and greater data redundancy
, While designing a new database structure, normalization does what?
Correct Answer-• Analyzes the relationship among the attributes within
each entity
• Determines if the structure can be improved through normalization
• Improves the existing data structure and creates an appropriate
database design
What is the objective of normalization? Correct Answer-Objective is to
ensure that each table conforms to the concept of well-formed relations
What makes up the normalization objective? Correct Answer-• Each
table represents a single subject
• Each row/column intersection contains only one value and not a group
of values
• No data item will be unnecessarily stored in more than one table
• All nonprime attributes in a table are dependent on the primary key
• Each table has no insertion, update, or deletion anomalies
When all tables are in at least 3NF, higher forms are not likely what?
Correct Answer-Higher forms are not likely to be encountered in
business environment
When normalization works one relation at a time, it does what? Correct
Answer-• Identifies the dependencies of a relation (table)
• Progressively breaks the relation up into a new set of relations
Answers
What is normalization? Correct Answer-Evaluating and correcting table
structures to minimize data redundancies
What are the benefits of normalization? Correct Answer-• Reduces data
anomalies
• Assigns attributes to tables based on determination
What are the normal forms? Correct Answer-• First normal form (1NF)
• Second normal form (2NF)
• Third normal form (3NF)
What makes up the structural point of view of normal forms? Correct
Answer-• Higher normal forms are better than lower normal forms
• Properly designed 3NF structures meet the requirement of fourth
normal form (4NF)
What is denormalization? Correct Answer-Produces a lower normal
form
What does denormalization result in? Correct Answer-• Results in
increased performance and greater data redundancy
, While designing a new database structure, normalization does what?
Correct Answer-• Analyzes the relationship among the attributes within
each entity
• Determines if the structure can be improved through normalization
• Improves the existing data structure and creates an appropriate
database design
What is the objective of normalization? Correct Answer-Objective is to
ensure that each table conforms to the concept of well-formed relations
What makes up the normalization objective? Correct Answer-• Each
table represents a single subject
• Each row/column intersection contains only one value and not a group
of values
• No data item will be unnecessarily stored in more than one table
• All nonprime attributes in a table are dependent on the primary key
• Each table has no insertion, update, or deletion anomalies
When all tables are in at least 3NF, higher forms are not likely what?
Correct Answer-Higher forms are not likely to be encountered in
business environment
When normalization works one relation at a time, it does what? Correct
Answer-• Identifies the dependencies of a relation (table)
• Progressively breaks the relation up into a new set of relations
