Dependency Functions Quiz

What is the meaning of full functional dependency in a database?

• Every non-key attribute fully depends on the primary key.

• Only some non-key attributes depend on some primary key.

• Non-key attributes depend on other non-key attributes.

• All attributes depend on foreign keys.

Partial functional dependency occurs when...

• Non-key attributes depend on the whole primary key.

• Non-key attributes depend on part of a composite primary key.

• Non-key attributes do not depend on any key.

• Non-key attributes depend on other non-key attributes.

Transitive functional dependency means...

• Non-key attributes depend on foreign keys.

• Non-key attributes depend on other non-key attributes, not directly on the primary key.

• All attributes fully depend on the primary key.

• There is no relationship between attributes.

In the Orders table, the Shipping Address attribute depends on the Customer ID through the Customer Name. This is an example of...

• Full functional dependency

• Partial functional dependency

• Transitive functional dependency

• No functional dependency

When a table has a composite primary key (e.g., Student ID + Course ID) and the Student Name attribute only depends on the Student ID, this is...

• Full functional dependency

• Partial functional dependency

• Transitive functional dependency

• Non-existent functional dependency

Why is full functional dependency important in database design?

• To reduce redundancy and data anomalies.

• To increase the number of tables.

• So that all attributes can depend on any key.

• So that the primary key can be changed at will.

If a non-key attribute directly depends on the whole primary key, we can say it is...

• Partial functional dependency

• Full functional dependency

• Transitive functional dependency

• Not normalized

In normalization, the goal of eliminating partial functional dependency is to achieve...

• Second Normal Form (2NF)

• First Normal Form (1NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

In the Sales table, the Discount attribute depends on the Original Price which depends on the Product ID. This indicates...

• Partial functional dependency

• Full functional dependency

• Transitive functional dependency

• No functional dependency

What is the effect if functional dependency is not properly handled in a database?

• Data becomes more consistent and faster to access.

• Redundancy and update anomalies occur.

• Data is more secure and organized.

• No effect on data integrity.