(Solved) : Using University Database Schema Discussed Class Write Sql Statements University Schema Di Q44137282 . . .
Using the university database schema discussed in class, write the SQL statements that do: 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 (e) For each student who took a course at least twice, show the course ID and the student ID. (5 marks) (f) Find the ID and name of instructors who never gave a grade ‘A’ in the courses they taught (note that instructors who never taught a course satisfy this condition). (5 marks) (g) Rewrite the previous query so that you make sure that the instructor taught at least one course. (5 marks) (h) Find the lowest, across all departments, of the per-department maximum salary. (3 marks) Show transcribed image text Using the university database schema discussed in class, write the SQL statements that do:
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
(e) For each student who took a course at least twice, show the course ID and the student ID. (5 marks) (f) Find the ID and name of instructors who never gave a grade ‘A’ in the courses they taught (note that instructors who never taught a course satisfy this condition). (5 marks) (g) Rewrite the previous query so that you make sure that the instructor taught at least one course. (5 marks) (h) Find the lowest, across all departments, of the per-department maximum salary. (3 marks)
Expert Answer
Answer to Using the university database schema discussed in class, write the SQL statements that do: University Schema Diagram stu…
OR