Answer (i) and (ii) only (1)(a) State(or underline) the appropriate attribute name(s) to identify the correct primary key for thisrelation, RaceEntryAndResult(RaceNumber, AthleteNumber, TimeSet).(b)Relations in a database should usually be fully normalised. Define what it means for a database to befully nomalised.(ii) Produce an Entity-Relationship diagram showing the degree of the three relationships that existbetween the entities.(iii)(a) Athlete number 72 is to be entered into race number 9. Write the SQL commands that are requiredto make this entry.(b) Define Referential Integrity, and state one advantage of it.(c) The database system is to be extended for use in an inter-school athletics league. Users at any schoolin the country will be able to access the system to input the results of races. For this reason, two usersmight try to access or update the system at the same time. Explain the conditions under whichsimultaneous access to a database could cause a problem, and how this could be dealt with. 7.A school stores information about its sports day in a relational database. The details of the track eventsare stored using the three relations presented below.Athlete (AthleteNumber, Forename, Surname, Class, Gender, DateOfBirth)Race (RaceNumber, Gender, Distance, Type, StartTime)RaceEntryAndRest:lt (RaceNun ber, AthieteNumber, TimeSet)Each athlete who takes part in a race is given a unique AthleteNumber. Athletes can run in more than onerace. If they do, they keep the same AthleteNumber for the entire day.Many races are run throughout the day. An example race would be the boys 80m, high jump, the thirdrace of the day, which starts at 13:30. The entry in the Race table for this race is shown in table below.RaceNumber3.GenderВoysDistanceТуре100mStartTime13:3008Table 1When an athlete is entered into a race, a record of the entry is created in the RaceEntryAndResult tuble.Initially, the TimeSet is recorded as 00:00.00 (meaning 0 minutes, 0 seconds, 0 hundredths of a second) toindicate that the race has not yet been run. After the race has been run, if the athlete successfullycompletes it, then their TimeSet value is updated to record the time that they achieved in minutes, secondsand hundreds of seconds. The TimeSet value remains at 00:00.00 for athletes who fail to complete therace. The primary keys in the Athlete and Race relations have been identified by underlining them. Thecorrect primary key for the RaceEntryAndResult relation has not been identified.

Question

Accepted Answer

Primary key - It is the attribute for which every value in table remains unique and not empty. The…