Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Rules In Database Systems Third International Workshop Rids 97 Sk Vde Sweden June 26 28 1997 Proceedings Lncs 1312

Authors: Andreas Geppert ,Mikael Berndtsson

1997th Edition

3540635165, 978-3540635161

More Books

Students also viewed these Databases questions