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 course_sections table. The new table will be
named course_sections_copy, and it will include data from the original course_sections table. This is the partial script:USE ischool;
# Run the following code to create a copy of the course_sections table.
DROP TABLE IF EXISTS course_sections_copy;
CREATE TABLE course_sections_copy
LIKE course_sections;
INSERT INTO course_sections_copy
SELECT *
FROM course_sections;
# Run these two queries (separately) to make sure the copy table
## perfectly matches the original course_sections table.
SELECT *
FROM course_sections;
SELECT *
FROM course_sections_copy;
# For this question, fill in the missing values in the following insert
statement.
## See question 1 instructions for more information.
INSERT INTO course_sections_copy
(section_id, section_number, semester, year, meeting_days,
start_time,
end_time, course_id, instructor_id, delivery_id,
format_id, location_id)
VALUES
(200,'0201',/*???*/,/*???*/,/*???*/,/*???*/,/*???*/,13,
/*???*/,1,1,/*???*/),
(201,/*???*/, 'Fall', 2024,/*???*/,/*???*/,/*???*/,/*???*/,
/*???*/,/*???*/,/*???*/,/*???*/),
(202,/*???*/,/*???*/,/*???*/,/*???*/,/*???*/,/*???*/,/*???*/,
/*???*/, NULL, NULL, /*???*/),
(/*???*/,/*???*/,/*???*/,/*???*/,'M','11:00','12:45',/*???*/,
132466116,/*???*/,/*???*/,51);
# Run this query to check whether the new rows have been inserted.
SELECT *
FROM course_sections_copy;
For this question, write two INSERT statements to add the following information to the
course_sections_copy table.
1. Insert 2 new rows for INST326 course sections into the course_sections_copy table.
The new course sections will be:
section ids: 200,201
section numbers: 0201,0202
semester and year: Fall 2024[for both rows]
meeting day and times: both meet on Wednesdays from 9AM to 12PM
course: INST326[for both rows]
instructor: Emmalee Allred [for both rows]
delivery and format: Face-to-face synchronous [for both rows]
location: Plants Sciences building, room 1140[for both rows]
2. Insert 2 new rows for INST414 course sections into the course_sections_copy table.
The new course sections will be:
section ids: 202,203
section numbers: 0201,0202
semester and year: Spring 2025[for both rows]
meeting day and times: both meet on Mondays from 11:30AM to 12:45PM
course: INST414[for both rows]
instructor: Baby Yoda Grogu [for both rows]
delivery and format: not defined [for both rows]
location: Plants Sciences building, room 1140[for both rows]

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!