Consider the relation instance STUDENT (Major, Stu_id, Activity, Name, Phone)

a. Identify all multi-valued dependencies in STUDENT.
b. Describe insertion, deletion, and update anomalies that accompany each of the multi-valued dependencies identified above. Are any of these multi-valued dependencies also functional dependencies?
c. Decompose STUDENT into a relational schema (i.e., a set of relation schemas) that exhibits attribute preservation, dependency preservation, and the presence of a lossless join decomposition.

Transcribed Image Text:

Actvity SWIMMING SWIMMING TENNIS Name COSTELLO COSTELLO COSTELLO tu id 100 100 100 100 150 250 200 ajor MUSIC ACCOUNTING MUSIC 444-5456 444-5458 444-5456 444-5455 444-5456 865-5456 865-5456 865-5456 UNTING STELL BROOKS ABBOTT COSTELLO ABBOTT MATH JOGGING SLEEPING SWIMMING EATING MATH MATH