Podcast
Questions and Answers
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?
- By removing the StudentMajor attribute (correct)
- By removing the StudentName attribute
- By removing the Dr. Smith value
- By removing the StudentID attribute
In the table with the primary key as (StudentID, CourseID), which attribute is a partial dependency?
In the table with the primary key as (StudentID, CourseID), which attribute is a partial dependency?
- DepartmentID
- ProfessorID
- Grade (correct)
- Salary
In the table with the candidate key as (CourseID, Semester), which attribute is a transitive dependency?
In the table with the candidate key as (CourseID, Semester), which attribute is a transitive dependency?
- MajorName (correct)
- RoomNumber
- Building
- InstructorName
Which of the following best describes normalization in the database design process?
Which of the following best describes normalization in the database design process?
Which normal form assigns attributes to tables based on determination?
Which normal form assigns attributes to tables based on determination?
What is the purpose of denormalization?
What is the purpose of denormalization?
Which of the following statements about normal forms is true?
Which of the following statements about normal forms is true?
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 is the purpose of normalization in database design?
What is the purpose of normalization in database design?
What is a surrogate key?
What is a surrogate key?
What should be done before creating table structures in database design?
What should be done before creating table structures in database design?
Which normal form requires that there are no transitive dependencies?
Which normal form requires that there are no transitive dependencies?
What is the correct definition of functional dependence?
What is the correct definition of functional dependence?
What is the main purpose of converting a dataset to First Normal Form (1NF)?
What is the main purpose of converting a dataset to First Normal Form (1NF)?
What is the correct term for a group of multiple entries of the same type that can exist for any single key attribute occurrence?
What is the correct term for a group of multiple entries of the same type that can exist for any single key attribute occurrence?
Which of the following best describes the purpose of normalization in database design?
Which of the following best describes the purpose of normalization in database design?
What does it mean for a table to be in 3NF?
What does it mean for a table to be in 3NF?
How does the normalization process work?
How does the normalization process work?
Which of the following best describes functional dependence in a table?
Which of the following best describes functional dependence in a table?
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 relationship names in data modeling be?
What should relationship names in data modeling be?
What should each entity represent in data modeling?
What should each entity represent in data modeling?
What should be clearly defined for each entity instance in data modeling?
What should be clearly defined for each entity instance in data modeling?
What should all entities be in data modeling?
What should all entities be in data modeling?
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?
When does the conversion to Second Normal Form (2NF) occur?
When does the conversion to Second Normal Form (2NF) occur?
In order to achieve Second Normal Form (2NF), what should be done to tables with partial dependencies?
In order to achieve Second Normal Form (2NF), what should be done to tables with partial dependencies?
What is the purpose of creating a separate table for the 'Publishers' in the Third Normal Form (3NF) conversion?
What is the purpose of creating a separate table for the 'Publishers' in the Third Normal Form (3NF) conversion?
Flashcards are hidden until you start studying
