please answer question number 2 with all the requirements

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). [1] 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