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.
Subscribe
Login
0 Comments