Question
PLEASE HELP ME WITH THIS I AM DESPERATE NEED OF MATERIAL TO STUDY AND UNDERSTAND IM ALREADY LATE ON THIS ASSIGNMENT AND NEED THE HELP!
PLEASE HELP ME WITH THIS I AM DESPERATE NEED OF MATERIAL TO STUDY AND UNDERSTAND IM ALREADY LATE ON THIS ASSIGNMENT AND NEED THE HELP! THANK YOU FOR TAKING THE TIME TO DO THIS! THIS IS SQL FOR DATABASE THEORY!
3.12 Write the following queries in SQL, using the university schema.
a. Create a new course CS-001, titled Weekly Seminar, with 0 credits.
b. Create a section of this course in Autumn 2009, with sec id of 1.
c. Enroll every student in the Comp. Sci. department in the above section.
d. Delete enrollments in the above section where the students name is Chavez.
e. Delete the course CS-001. What will happen if you run this delete statement without first deleting offerings (sections) of this course.
f. Delete all takestuples corresponding to any section of any course with the word database as a part of the title; ignore case when matching the word with the title.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started