- You can only use SQL statements in your solutions. 1. Create a database named E01_group_ID ID is your ID at the university (group is the group number) 2. Download data from the Platon platform (Training path elements - Introduction to Database (CILISE003CI) - 20217-1 W) and upload to your database (DATA EXAM_20220113.TXT) 3. Modify the structure - create a primary key 4. Calculate how many women there are in each age group, prepare a statement in a separate table (table name Number_of_women) with the structure: year, number_of_women 5. Create a table named Surname with unique data from the Person table. The structure should be as shown in the picture. 6. Modify the Person table so that the table includes the foreign key from the Surname table. Before Person name1 varchar(20) N surname varchar(40) N gender char(10) N Birth Date date N zzzz After Person name1 varchar(20) N gender char(10) Birth Date date id_surname integer (10) Id person Integer(10) surname id surname integer (10) i sumame varchar(40) N 7. Add your data to the resulting structure (your details - name, surname, date of birth, gender) You can only use SQL statements in your solutions. 1. Create a database named E01_group_ID ID is your ID at the university (group is the group number) 2. Download data from the Platon platform (Training path elements - Introduction to Database (CIISE003CT) - 2021Z-1 W) and upload to your database (DATA EXAM_20220113.TXT) 3. Modify the structure - create a primary key 4. Calculate how many women there are in each age group, prepare a statement in a separate table (table name Number_of_women) with the structure: year, number_of_women 5. Create a table named Surname with unique data from the Person table. The structure should be as shown in the picture. 6. Modify the Person table so that the table includes the foreign key from the Surname table. Before Person name1 varchar(20) NL surname varchar(40) NL gender char(10) N BirthDate date N After Person D name varchar(20) N gender char(10) IN Birth Date date N id_surname integer (10) id person Integer(10) surname id_sumamo integer (10) sumame varchar(40) N 7. Add your data to the resulting structure (your details - name, sumame, date of birth, gender) 8. Prepare a script with the solution and save it in a file with the TXT extension. Place the file on the