solve all the steps from 1-9 please

Tasks/Assignments(s) Creating Database objects: 1: Using the Data Definition Language statement, create new database named School. CREATE DATABSE School 2: Create the tables Student and Teacher with the following columns. (Declare the corresponding primary and foreign keys). Each student taught by one teacher. Each teacher taught one or more students. 3: Delete column Std_Birth from Student table. 4: Insert new four rows into the Teacher table with the following values: 5: Insert new six rows into the Student table with the following values: Course Code- Couse Name 15 I Drartiral Saceinn Dlan 6: Add new column Address (varchar(20), null ) to Student table. 7: change for student No 101 the group No to G4. 8: change for student No 102 the teacher No to 1001 and the Student Name to Nasser. 9: create view containing a list of Names and IDs of all students who teacher Id is 1002. 1. Outcome A: Student will be asked to list some examples of DML queries 2. Outcome B: Students will be divided into groups to solve the assessments 5- Resources Suggest further resources for the students to manage their learning after the class. Make sure that the resources are specific and different to suit all students, e. g. Figures, Tables, Links, etc