Podcast
Questions and Answers
Which of the following is NOT one of the normal forms discussed in the text?
Which of the following is NOT one of the normal forms discussed in the text?
- 3NF
- 1NF
- 2NF
- 4NF (correct)
What is the purpose of normalization in the database design process?
What is the purpose of normalization in the database design process?
- To check ERD requirements
- To generate information efficiently
- To increase data redundancy
- To minimize data redundancies (correct)
What does denormalization involve?
What does denormalization involve?
- Reducing data anomalies
- Assigning attributes to tables based on determination
- Producing a lower normal form (correct)
- Transforming normal forms from lower to higher
Which of the following is a recommended naming convention for entity names in data modeling?
Which of the following is a recommended naming convention for entity names in data modeling?
What should attribute names in data modeling be descriptive of?
What should attribute names in data modeling be descriptive of?
What should each entity represent in data modeling?
What should each entity represent in data modeling?
Which of the following is NOT a goal of the normalization process?
Which of the following is NOT a goal of the normalization process?
What does it mean for an attribute to be fully functionally dependent on another attribute?
What does it mean for an attribute to be fully functionally dependent on another attribute?
In the 'Employees' table, which attribute(s) is/are functionally dependent on 'EmployeeID'?
In the 'Employees' table, which attribute(s) is/are functionally dependent on 'EmployeeID'?
In the 'Students' table, which attribute(s) is/are functionally dependent on 'StudentID'?
In the 'Students' table, which attribute(s) is/are functionally dependent on 'StudentID'?
Which normal form describes a tabular format in which all key attributes are defined, there are no multi-valued attributes, and all attributes are dependent on the primary key?
Which normal form describes a tabular format in which all key attributes are defined, there are no multi-valued attributes, and all attributes are dependent on the primary key?
Which normal form requires the elimination of partial dependencies and makes new tables to achieve this?
Which normal form requires the elimination of partial dependencies and makes new tables to achieve this?
Which normal form requires the elimination of transitive dependencies and makes new tables to achieve this?
Which normal form requires the elimination of transitive dependencies and makes new tables to achieve this?
What is the purpose of creating separate tables in the process of achieving higher normal forms?
What is the purpose of creating separate tables in the process of achieving higher normal forms?
Which attribute represents the number of hours an employee worked on a specific project?
Which attribute represents the number of hours an employee worked on a specific project?
What does CHG_HOUR represent?
What does CHG_HOUR represent?
What is the purpose of normalization in database design?
What is the purpose of normalization in database design?
What are surrogate keys used for in database design?
What are surrogate keys used for in database design?
Which normal form requires that there be no transitive dependencies?
Which normal form requires that there be no transitive dependencies?
Which attribute is known as the dependent attribute in functional dependence?
Which attribute is known as the dependent attribute in functional dependence?
Which attribute is fully functionally dependent on a composite key A but not on any subset of that composite key?
Which attribute is fully functionally dependent on a composite key A but not on any subset of that composite key?
What is the first step in the conversion to First Normal Form (1NF)?
What is the first step in the conversion to First Normal Form (1NF)?
Which of the following is an example of partial dependency?
Which of the following is an example of partial dependency?
Which of the following is an example of transitive dependency?
Which of the following is an example of transitive dependency?
In the first example, why is 'StudentAdvisor' not fully functionally dependent on 'StudentID'?
In the first example, why is 'StudentAdvisor' not fully functionally dependent on 'StudentID'?
In the second example, how did they ensure that 'StudentAdvisor' is fully functionally dependent on 'StudentID'?
In the second example, how did they ensure that 'StudentAdvisor' is fully functionally dependent on 'StudentID'?
