Data Structure and Analysis

Play an AI-generated podcast conversation about this lesson

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?

To check ERD requirements

To generate information efficiently

To increase data redundancy

To minimize data redundancies (correct)

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?

Abbreviate entity names and use familiar nouns Signup and view all the answers

What should attribute names in data modeling be descriptive of?

The characteristic being represented Signup and view all the answers

What should each entity represent in data modeling?

A single subject Signup and view all the answers

Which of the following is NOT a goal of the normalization process?

Ensuring that all tables are in at least 3NF Signup and view all the answers

What does it mean for an attribute to be fully functionally dependent on another attribute?

The attribute can be determined by only one other attribute Signup and view all the answers

In the 'Employees' table, which attribute(s) is/are functionally dependent on 'EmployeeID'?

EmployeeName Signup and view all the answers

In the 'Students' table, which attribute(s) is/are functionally dependent on 'StudentID'?

StudentAdvisor Signup and view all the answers

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?

First Normal Form (1NF) Signup and view all the answers

Which normal form requires the elimination of partial dependencies and makes new tables to achieve this?

Second Normal Form (2NF) Signup and view all the answers

Which normal form requires the elimination of transitive dependencies and makes new tables to achieve this?

Third Normal Form (3NF) Signup and view all the answers

What is the purpose of creating separate tables in the process of achieving higher normal forms?

To improve data integrity and eliminate redundancies Signup and view all the answers

Which attribute represents the number of hours an employee worked on a specific project?

HOURS Signup and view all the answers

What does CHG_HOUR represent?

The amount charge per hour Signup and view all the answers

What is the purpose of normalization in database design?

To eliminate data redundancies Signup and view all the answers

What are surrogate keys used for in database design?

To create unique identifiers when the primary key is unsuitable Signup and view all the answers

Which normal form requires that there be no transitive dependencies?

Third normal form (3NF) Signup and view all the answers

Which attribute is known as the dependent attribute in functional dependence?

Attribute B Signup and view all the answers

Which attribute is fully functionally dependent on a composite key A but not on any subset of that composite key?

Attribute B Signup and view all the answers

What is the first step in the conversion to First Normal Form (1NF)?

Eliminate repeating groups Signup and view all the answers

Which of the following is an example of partial dependency?

The Grade in the table depends on both StudentID and CourseID, but the Professor only depends on the CourseID. Signup and view all the answers

Which of the following is an example of transitive dependency?

The MajorName in the table is dependent on the MajorID, and the Department is dependent on the MajorName. Signup and view all the answers

In the first example, why is 'StudentAdvisor' not fully functionally dependent on 'StudentID'?

'StudentAdvisor' can also be determined by the 'StudentMajor' attribute. Signup and view all the answers

In the second example, how did they ensure that 'StudentAdvisor' is fully functionally dependent on 'StudentID'?

They removed any other potential sources of dependency. Signup and view all the answers