Question: Execute this partial script to create a copy of the course _ sections table. The new table will be named course _ sections _ copy,
Execute this partial script to create a copy of the coursesections table. The new table will be
named coursesectionscopy, and it will include data from the original coursesections table. This is the partial script:USE ischool;
# Run the following code to create a copy of the coursesections table.
DROP TABLE IF EXISTS coursesectionscopy;
CREATE TABLE coursesectionscopy
LIKE coursesections;
INSERT INTO coursesectionscopy
SELECT
FROM coursesections;
# Run these two queries separately to make sure the copy table
## perfectly matches the original coursesections table.
SELECT
FROM coursesections;
SELECT
FROM coursesectionscopy;
# For this question, fill in the missing values in the following insert
statement.
## See question instructions for more information.
INSERT INTO coursesectionscopy
sectionid sectionnumber, semester, year, meetingdays,
starttime,
endtime, courseid instructorid deliveryid
formatid locationid
VALUES
'Fall',
NULL, NULL,
M::
;
# Run this query to check whether the new rows have been inserted.
SELECT
FROM coursesectionscopy;
For this question, write two INSERT statements to add the following information to the
coursesectionscopy table.
Insert new rows for INST course sections into the coursesectionscopy table.
The new course sections will be:
section ids:
section numbers:
semester and year: Fall for both rows
meeting day and times: both meet on Wednesdays from AM to PM
course: INSTfor both rows
instructor: Emmalee Allred for both rows
delivery and format: Facetoface synchronous for both rows
location: Plants Sciences building, room for both rows
Insert new rows for INST course sections into the coursesectionscopy table.
The new course sections will be:
section ids:
section numbers:
semester and year: Spring for both rows
meeting day and times: both meet on Mondays from :AM to :PM
course: INSTfor both rows
instructor: Baby Yoda Grogu for both rows
delivery and format: not defined for both rows
location: Plants Sciences building, room for both rows
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
