Examine the relations shown on the last page of this handout. (20 points)

a. For each relation, identify which attribute(s) would be considered suitable

candidate keys. Explain your rationale.

b. Next, in cases where there is more than one candidate key in a relation, identify

which attribute(s) should be used as the primary key and which would be considered as an alternate key Explain your rationale