Applications of Functional Dependencies in Database Management System

{roll_no, name} → name (correct)

{dept_name} → dept_building

dept_building → roll_no

{name} → roll_no

Non-Trivial functional dependency

Trivial functional dependency (correct)

Transitive functional dependency

Multivalued functional dependency

{roll_no, name} → dept_building (correct)

{name} → roll_no

dept_building → roll_no

{dept_name} → dept_building

<p>The independent attribute(s)</p> Signup and view all the answers

<p>{roll_no} → dept_name</p> Signup and view all the answers

<p>Transitivity rule</p> Signup and view all the answers