Consider the relation schema ACTIVITY (Stu#, Sport, Cost) and associated relation instance shown below:

a. What is the minimal cover of ACTIVITY?
b. What, if any, immediate normal form violation exists in ACTIVITY?
c. Discuss each of the following three decompositions in the context of attribute preservation, dependency preservation, and lossless-join decomposition?
Da: R1a: STU-SPORT (Stu#, Sport)............R2a: SPORT-COST (Sport, Cost)
Db: R1b: STU-SPORT (Stu#, Sport) ............R2b: STU-COST (Stu#, Cost)
Dc: R1c: STU-COST (Stu#, Cost) ...............R2c: SPORT-COST (Sport, Cost)

Transcribed Image Text:

Stu# 100 150 175 200 Sport SKIING TENNIS KARATE TENNIS Cost 200 50 50 50