(Solved): Creating Database objects: 1: Using the Data Definition Language statement, create new database nam ...

Creating Database objects: 1: Using the Data Definition Language statement, create new database named Sehool. 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: 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 I002