Advanced level school Python programming. need helps

7. In a football league, there are several teams. A database is created to store data about the clubs and the players that play for them. - Each player belongs to a single club. - A club can have multiple players, but only one coach. - Each player can play multiple positions. This table shows the data about the clubs and their players: (a) Explain whether the above table is normalised. The following table is created to keep track of the physical attributes required to play these positions, allowing the coach to better monitor the players' development. Table: POSITION A relational database is to be used. Using the information above, design the database that consists of a number of tables. (b) Draw the Entity-Relationship (E-R) diagram to show the tables in third normal form (3NF) and their relationships between them. A table description can be expressed as: TableName (Attribute1, Attribute2, Attribute3, . . .) The primary key is indicated by underlining one or more attributes. Foreign keys are indicated by using a dashed underline. The POSITION table has been identified with the table descriptions: POSITION (PosCode, PosName, MainSkill, SecondarySkill) (c) Using the information given, write table descriptions for the other tables you identified in part (b). The player McGuy changed his club from Zombies to the Pies. (d) Write an SQL query to reflect this in the database. A new player joined the club Zombies. The following are his personal information: (e) Write SQL query statement(s) to add the player into the database. (f) Write an SQL query to output the name, club name and age of all the players with 'Speed' as their main skill, ordered by their age from youngest to oldest. (g) The Zombies collected their players' health data to monitor their development and match fitness. This data was later used in advertisements for an energy drink. State one Data Protection Obligation breached under PDPA, and explain what the club should have done before using the data in advertisements