Functional and Transitive Dependencies Quiz No 1

What does a functional dependency represent in a database table?

• A relationship between two tables.

• A column whose values are unique.

• A relationship between two or more columns in the same table.

• A column whose values depend on another column in the same table.

Which of the following best defines a transitive dependency?

• A dependency where one column uniquely identifies each row.

• A dependency where a column's value indirectly depends on another column through a third column.

• A dependency where all columns in a table are interdependent.

• A dependency where a column's value depends on another column in the same table.

In database normalization, what is the primary goal when handling functional dependencies?

• To eliminate all dependencies between columns.

• To ensure each column uniquely identifies each row.

• To minimize redundancy by organizing data and eliminating non-key attributes dependent on other non-key attributes.

• To ensure that all columns are dependent on the primary key.

Which normalization form deals specifically with removing transitive dependencies?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

A transitive dependency occurs when:

• A column's value directly depends on the primary key.

• A column's value indirectly depends on the primary key through another non-key attribute.

• All columns in a table depend on each other.

• A column's value cannot be derived from other columns.

What does it mean when a column is functionally dependent on the primary key?

• The column uniquely identifies each row.

• The column's value can be derived from the primary key.

• The column has no relationship with the primary key.

• The column contains unique values.

In a student-course registration system, if Course ID -> Course Name and Student ID -> Course ID, what dependency is present?

• Functional dependency

• Transitive dependency

• Partial dependency

• Composite dependency

What is the main purpose of normalizing tables in a database?

• To increase redundancy for faster query performance.

• To minimize data integrity and consistency.

• To decrease storage space requirements.

• To organize data, reduce anomalies, and improve efficiency.

Which of the following is an example of a functional dependency?

• Student ID -> Student Name

• Course ID -> Course Instructor

• Course ID, Student ID -> Grade

• Student Name -> Student Address

What does it mean if a table is in 2nd normal form (2NF)?

• It contains no repeating groups.

• It is in 1st normal form (1NF) and has no transitive dependencies.

• It has a composite primary key.

• It contains no null values.