Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Functional-Dependency
| Question 43 |
In functional dependency between two sets of attribute A and B then set of attributes A of database is classified as:
| Top right side | |
| Down left side | |
| Left hand side | |
| Right hand side |
Question 43 Explanation:
A functional dependency (FD) is a relationship between two attributes, typically between the PK and other non-key attributes within a table. For any relation R, attribute Y is functionally
dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y.
This relationship is indicated by the representation below :
X ———–> Y
The left side of the above FD diagram is called the determinant, and the right side is the dependent.
dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y.
This relationship is indicated by the representation below :
X ———–> Y
The left side of the above FD diagram is called the determinant, and the right side is the dependent.
Correct Answer: C
Question 43 Explanation:
A functional dependency (FD) is a relationship between two attributes, typically between the PK and other non-key attributes within a table. For any relation R, attribute Y is functionally
dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y.
This relationship is indicated by the representation below :
X ———–> Y
The left side of the above FD diagram is called the determinant, and the right side is the dependent.
dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y.
This relationship is indicated by the representation below :
X ———–> Y
The left side of the above FD diagram is called the determinant, and the right side is the dependent.