Question: Write SQL update statements to do the following on the database schema shown in Figure 1 ( Student and course database ) . a .

Write SQL update statements to do the following on the database schema shown in Figure 1(Student and course database).
a. Create table student, course and section only. Provide all necessary constraints.
b. Insert a new student, 'Johnson', 25,1, 'Math'>, in the database.
c. Change the class of student 'Smith' to 2.
d. Insert a new course, 'Knowledge Engineering', 'cs4390',3,'cs'>.
e. Delete the record for the student whose name is 'Smith' and whose student number is 17. STUDENT
COURSE
SECTION
GRADE_REPORT
PREREQUISITE
Write SQL update statements to do the following

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 Programming Questions!

Q:

We used microsoft access in class. SQL 4.13. Write SQL update statements to do the following on the database schema shown in Figure 1.2 a. Insert a new student, , in the database. b. Change the class...

Q:

Write SQL update statements to do the following on the database schema shown in Figure 1.2. (a) Insert a new student in the database. (b) Change the class of student 'Smith' to 2. (c) Insert a new...

Q:

6.13. Write SQL update statements to do the following on the database schema shown in Figure 1.2. a. Insert a new student, , in the database. b. Change the class of student Smith' to 2. c. Insert a...

Q:

4.13. Write SQL update statements to do the following on the database schema shown in Figure 1.2. a. Insert a new student, Johnson, 25, 1, 'Math'>, in the database. b. Change the class of student...

Q:

Selected Bibliography 205 6.13. Write SQL update statements to do the following on the database schema shown in Figure 1.2. a. Insert a new student.

Q:

Create a database in MySQL using the attached mysqluniversity.sql file. Use the command: mysql - u username - p mysqluniversity.sql , where username may be root or other user that you have configured...

Q:

QUESTION 5 NOTE: All SQL syntax must be correct, missing characters will be penalized! 5 . a . The Finance Department of SOUTHERN AFRICA NAZARENE UNIVERSITY stores the Bonus field in the Employee...

Q:

3. Write four SQL update statements to do the following updates on the database schema shown in Figure 1.2. Show the affected tables after update through script file in sqlplus and in a script file...

Q:

Write SQL DDL statements that implement the following queries. Find all CS students who live in Edinburg. Find all possible pairs (combinations) of students and professors. Find all possible pairs...

Q:

QUESTION 3 ( 3 0 MARKS ) Suppose you have the following table named Student. The table is stored in a Database called School. Student Student _ ID Student _ Name Student _ Surname Student _ Phone...

Q:

The time to assemble the first unit on a production line is 10 hours. The learning rate is 0.94. Approximately how long will it take for the seventh unit to be assembled? The number of hours needed...

Q:

Calculate the work done by the force field F = (cos x + y)i + (e' + x)j as a particle moves anti-clockwise along the triangular path from (0,0) to (1,0) to (0,1) back to (0,0) as shown in the diagram...

Q:

Bloomberg Spreadsheet Analysis How do changes to the maturity range and outstanding amount thresholds impact the results of a fixed income BQL query? 'Select at that apply. ) The conservative...

Q:

What data analyticsWhat data analytics tasks are needed to handle the following problem: a manufacturing company plans to use previous order and transaction data to predict whether its customers will