Using the F$1\_2023.$RaceResults dataset and the other resources do the following:

$1$NF $($repeating groups have already been eliminated from the dataset and I have identified the trivial super key for you to start with$)(25$ points$)$

Identify and list any candidate keys $($be sure to verify that they are valid candidate keys$)$

Select a primary key from the candidate keys, if you identified multiple candidate keys explain the reasons for your choice

Create the $1$NF dependency diagram $($remember to color code your primary key attributes and non$-$prime attributes$)$

Identify any partial dependencies on your $1$NF dependency diagram

$2$NF $(50$ points$)$

Create the $2$NF dependency diagram that eliminates all partial dependencies

Identify any transitive dependencies on your $2$NF dependency diagram

$3$NF $(50$ points$)$

Create the $3$NF dependency diagram that eliminates all transitive dependencies