Question: Q2) UPDATE (40 points) First, create a table course_sections_copy then insert all the data from the original table. When creating the tables, preserve column
Q2) UPDATE (40 points) First, create a table course_sections_copy then insert all the data from the original table. When creating the tables, preserve column attributes and indexes (this can be done with the LIKE keyword). To allow for repeated clean executions of your script, precede the statements with DROP TABLE statements. To ensure that the script will run cleanly even when the tables have not yet been created, use DROP TABLE IF EXISTS. Write update statements to change Fall 2021 records to create information for the Fall 2023 courses and sections offered in Fall 2021 are being offered again in Fall 2023. However, all the online courses and sections have been changed to blended delivery. All the face-to-face delivery courses will place in the same locations as they did in Fall 2021 but the blended courses will take place in Hornbake, Room 103. Then, write a SELECT query that returns details of the courses and sectio sort as shown in the picture below. HINT: You may need to turn off the SQL_SAFE_UPDATES system variable as we did in class. Course ID Section No. Term 0201 0301 0101 0102 1 1 2 2 2 2 3 4 5 7 7 7 7 7 7 0103 01xx 0102 0101 0101 0101 0102 IM01 0101 0101 0102 0101 0101 0101 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 75 80 81 82 99 rows should be returned. Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Fall 2023 Location F Computer Science Instructional Center Room #1121 John S Toll Physics Building Room #4221 John S Toll Physics Building Room #1204 Engineering Classroom Building (Martin) Room #3106 Edward St John Learning Center Room #2204 Plant Sciences Room #1130 sters from w Edward St John Learning Center Room #1224 Edward St John Learning Center Room # 215 Plant Sciences Room #1140 Skinner Building Room #200 Hornbake Room # 0302H Hornbake Room #105 Atlantic Building Room # 2330 Microbiology Building Room #1207 Plant Sciences Room #1117 John S Toll Physics Building Room #1204 Jimenez Building Room #205 Tawes Fine Arts Building Room #320 nec Do not post on he Hornbake Room #105 Atlantic Building Room #1106 Plant Sciences Room #1146 violation & co st. for the Fall 2023 term and Fall 2023 Fall 2023 Fall 2023 Fall 2023 Atlantic Building Room #1106 Fall 2023 Computer Science Instructional Center Room #1121 JM Patterson Building Room # 1109 Fall 2023 Fall 2023 Edward St John Learning Center Room #1215 licy.
Step by Step Solution
There are 3 Steps involved in it
The question presents a task that involves creating a copy of an existing table named coursesections updating records from Fall 2021 to create new rec... View full answer
Get step-by-step solutions from verified subject matter experts
