Functional Dependency (FD) Quiz

What is the purpose of Functional Dependency (FD)?

• Create anomalies in a relation

• Increase redundancy and storage space

• Limit data access

• Ensure data accuracy and consistency

Which type of dependency occurs when one attribute uniquely determines another attribute?

• Insert anomaly

• Fully functional dependency

• Transitive functional dependency

• Partial functional dependency

What type of dependency exists when a non-primary key column depends on only part of a composite primary key?

• Partial dependency

• Transitive dependency

• Fully functional dependency

• Insert anomaly

Which anomaly occurs when you can't add a new row to a database because some required information is missing?

• Insert anomaly

• Delete anomaly

• Update anomaly

• Partial dependency

What is the purpose of a Functional Dependency Diagram?

• Reduce data integrity

• Maximize redundancy in a database

• Create anomalies in a relation

• Illustrate various functional dependencies in a table

Which type of dependency occurs when a non-primary key column depends on another non-primary key column?

• Partial dependency

• Fully functional dependency

• Delete anomaly

• Transitive dependency