Chapter 2, Problem 2.25RQ

Explanation of Solution

Meaning of the Equation:

The given expression is,

A-> (B, C)

Explanation:

The meaning of the following equation is:

• Given a value for A, user can determine the value of both B and C simultaneously, represented as composite (B, C).
• Composite (B, C) is functionally dependent on A.
• A is determinant of the composite (B, C).

Example:

• For a table Employee containing attributes ‘employee_id’, ‘employee_name’ and ‘employee_department’, it is observed that user can fill an online form asking to enter the ‘employee_id’ and the Database Management System (DBMS) searches the employee database and retrieves the information about ‘employee_name’ and ‘employee_department’ simultaneously...