InterviewSolution
| 1. |
What Is Multi-valued Dependency? |
|
Answer» A multi-valued dependency is the situation when an attribute (ASSUME B) is dependent on another attribute (assume A). However, there are MULTIPLE rows in a table representing the dependency. This situation can happen when there is at least one more attribute which is dependent on A and it requires to have multiple rows of A and B to represent all the POSSIBLE COMBINATIONS. A multi-valued dependency is represented by A->> B. A multi-valued dependency is the situation when an attribute (assume B) is dependent on another attribute (assume A). However, there are multiple rows in a table representing the dependency. This situation can happen when there is at least one more attribute which is dependent on A and it requires to have multiple rows of A and B to represent all the possible combinations. A multi-valued dependency is represented by A->> B. |
|