The following table records the results for would-be actors who are undergoing a preliminary screening audition for a particular role in a play. Any actor who is turned down for a role, in the preliminary screening, is not allowed to re-audition for that role again. (Everyone who passes will be re-auditioned later along with others who passed the preliminary screening, and that data will be put in a separate table.)

Actor	Role	AuditionDate	Result
Aaryan Chaudary	Julius Caesar	2018-09-13	reject
Aaryan Chaudary	Brutus	2018-09-14	pass
Barry Evans	Julius Caesar	2018-09-13	pass
Isaac Biko	Cassius	2018-09-13	pass
Isaac Biko	Julius Caesar	2018-09-13	pass

The primary key of this table is Actor + Role.

Question 1

What bad consequences could follow if, in creating the table before we added the data we defined the primary key of the table as:

(a) Actor alone?

(b) Role alone?

(c) AuditionDate Alone?

(d) Actor + Role + AuditionDate?

(e) Actor + Role + AuditionDate + Result?

Question 2

Suppose it is decided to allow actors to re-audition for roles for which they were initially rejected, at a later date. Would we need to change the definition of the primary key? If we didnt change it, what problem might arise? If we changed it, what would the new key be? Explain your answer.