Explanation:If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from this source. 4. Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
A. Unique-role assumption
B. Unique-key assignment
C. Role intergral assignment
D. None of the mentioned
Answer:A
Explanation:If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from this source. 4. Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
A. Unique-role assumption B. Unique-key assignment C. Role intergral assignment D. None of the mentioned
Explanation:A desirable feature of a database design is the unique-role assumption, which means that each attribute name has a unique meaning in the database. 5. What is the best way to represent the attributes in a large database?