Describe and explain how to identify functional dependencies, identify determinants and dependent attributes in a database.
Describe and explain how to identify functional dependencies, identify determinants and dependent attributes in a database.
Functional dependencies are used to identify the dependency of different attributes on each other. When explaining dependencies, we have some attributes that may determine other attributes i.e. A may determine B or A>>B which means that B is functionally dependent on A. When A is manipulated in some arithmetic form, it gives arise to B. There are also cases when two functional attributes combine to determine one other Attribute. For example if A and C functional attributes define B, We can say that ( A & C) >> B.