Question: 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

 Creating Database objects: 1: Using the Data Definition Language statement, create

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!