Question $2$a: $[$Marks $=10)$ A football club uses the table below to record details of players and the positions in which they can play. Each player can play in up to a maximum of three positions: playerID playerName Positions P$1$ Lionel Messi Forward, Centre Midfield P$2$ Cristiano Ronaldo Forward, Left Midfield, Right Midfield P$3$ Philippa Lahm Right Back, Defensive Midfield $(1)$ Explain why this table is not in "First Normal Form" $(1$NF$).(2$ marks$)($ii$)$ Show how this table can be transformed into $1$NF tables. Give two possible solutions. $(8$ marks$)$ Question $2$b: $[$Marks $=10)$ The table shown below stores details of students and the overall grade each student obtained in different modules. The Primary key is $($StudentiD$,$ ModulelD$).$ Grade StudentID S$001$ S$001$ S$002$ Student Name Smith Smith Ford ModuleID M$01$ MO$2$ M$01$ ModuleName Java Databases Java A $$ B B B $($ Which Normal Form does the above table violate and why? $(2$ marks$)()$ Give an example of an update anomaly and an example of a delete anomaly that may occur if the table is left un$-$normalized. Explain the problems that marks$)($ili$)$ Show how you would normalize the table. $(4$ marks$)$ Attach File Browse Local Files Browse Content Collection