When is a functional dependency F said to be minimal-01376
This subjective question is related to the book/course
vu eng301 Business Communication.
It can also be found in
vu eng301 Mid Term Solved Past Paper No. 1.
Functional Dependencies and Keys
We can determine the keys of a relation after seeing its functional dependencies. The determinant of functional dependency that determines all attributes of that table is the super key. Super key is an attribute or a set of attributes that identifies an entity uniquely. In a table, a super key is any column or set of columns whose values can be used to distinguish one row from another. A minimal super key is the candidate key , so if a determinant of functional dependency determines all attributes of that relation then it is definitely a super key and if there is no other functional dependency whereas a subset of this determinant is a super key then it is a candidate key. So the functional dependencies help to identify keys. We have an example as under:
