Chapter 2, Problem 2.23RQ

Explanation of Solution

Functional dependency:

• An association between two attributes or two set of attributes in a same relational database table which is having some constraints is known as functional dependency.
• In a table, one attribute is functionally dependent on another attribute to take one value.

Example:

Consider that if Column A uniquely identifies the Column B of the same table then it is represented as A->B which means that “B” is functionally dependent on “A”.

Let assume that the student table contains the attributes such as “stud_id”, “stud_name” and “stud_age”. From this table, the “stud_id” attribute can uniquely identifies the “stud_name” attribute because the student can easily represent the student name associated with it...