In a database about competitors in the 2021 Tokyo Olympics, information held includes CID and Cname (the ID and name of the competing sportsperson), TeamName, TeamCoach, EventName, Event-Date and TeamRating.

Assume the following functional dependencies apply:

CID -> Cname, TeamName TeamName -> TeamCoach EventName -> EventDate TeamName, EventName -> TeamRating

Consider an initial design of a relation schema for the database:

Competitor(CID, EventName, Cname, TeamName, TeamCoach, EventDate, TeamRating)

Q1.1

a) Indicate the primary key of the relation.

b) Identify and describe any sources of redundancy.

c) Illustrate, using one example for each type of anomaly, how the Competitor relation could be subject to an

i) insert anomaly

ii) deletion anomaly

iii) update anomaly

Q1.2

Perform a lossless decomposition of the Competitor relation into relations in 3NF. For each resulting relation, underline the primary key and denote any foreign keys with asterisks (*).