Answer Happy

Write SQL queries for the following sentences considering the given relational schema of university database. section course id sec id semester year building TOOM_NO time_slot_id Ĵ† classroom building TOOM_no capacity (i) (ii) takes ID Course_id sec_id semester year grade time_slot time_slot id day start time end_time teaches ID course_id sec id semester year course course id title dept_name credits prereq course id prereq id student name dept_name tot cred department dept_name building budget instructor ID name dept_name salary advisor s_id [5 points] Suppose full name of the instructors are stored as atomic value where parts of names are separated by blank space. Find all instructors whose First name starts with "Vic". [5 points] Update the salary of each instructor to 10000 times the number of course sections they have taught