(Solved) : 3 33 Using University Database Schema Discussed Class Write Sql Statements Create New Cour Q44120799 . . .
3:33 Using the university database schema discussed in class, write the SQL statements that do: a Create a new course (“Aces of Databases”) with ID (“COMP5118”) in the Computer Science department (“Comp. Sci.”) with 0 credit hours. (3 marks) b Create a section ‘A’ for this course in the Winter of 2020 with no known location or time, yet. (4 marks) c Enroll all students in the department into this course. (5 marks) d One student with ID 12345 cannot take this course because of violating the prerequisite requirements (didn’t pass COMP3005). Unregister this student from the new section. (3 marks) University Schema Diagram student takes ID course_id sec_id semester year grade ID name dept_name tot_cred advisor course course_id title dept_name credits section course id sec_id semester year building room_no time_slot_id department dept name building budget s_id i_id time_slot time slot_id day start_time end_time instructor classroom building room no capacity prereq course_id prereq id ID name dept_name salary teaches ID course id sec id semester year Show transcribed image text 3:33 Using the university database schema discussed in class, write the SQL statements that do: a Create a new course (“Aces of Databases”) with ID (“COMP5118”) in the Computer Science department (“Comp. Sci.”) with 0 credit hours. (3 marks) b Create a section ‘A’ for this course in the Winter of 2020 with no known location or time, yet. (4 marks) c Enroll all students in the department into this course. (5 marks) d One student with ID 12345 cannot take this course because of violating the prerequisite requirements (didn’t pass COMP3005). Unregister this student from the new section. (3 marks)
University Schema Diagram student takes ID course_id sec_id semester year grade ID name dept_name tot_cred advisor course course_id title dept_name credits section course id sec_id semester year building room_no time_slot_id department dept name building budget s_id i_id time_slot time slot_id day start_time end_time instructor classroom building room no capacity prereq course_id prereq id ID name dept_name salary teaches ID course id sec id semester year
Expert Answer
Answer to 3:33 Using the university database schema discussed in class, write the SQL statements that do: a Create a new course (“…
OR