Write SQL queries for the following sentences considering the given relational schema of university database. student takes ID dept_neme lot_crad semester yar grade section COurse department advisor...


Write SQL queries for the following sentences considering the given relational schema of university<br>database.<br>student<br>takes<br>ID<br>dept_neme<br>lot_crad<br>semester<br>yar<br>grade<br>section<br>COurse<br>department<br>advisor<br>COuTse id<br>se<br>semester<br>COurse il<br>title<br>dept_name<br>building<br>baulget<br>dept name<br>credits<br>Lid<br>time_slot<br>budlding<br>TOO_rio<br>time_slot_id<br>time slot_i<br>stirt time<br>end_time<br>prereg<br>instructor<br>classroom<br>building<br>neme<br>dept_me<br>capacity<br>teaches<br>salary<br>ID<br>sec<br>semester<br>ver<br>Suppose full name of the instructors are stored as atomic value where parts of names are<br>separated by blank space. Find all instructors who has last name “Rob

Extracted text: Write SQL queries for the following sentences considering the given relational schema of university database. student takes ID dept_neme lot_crad semester yar grade section COurse department advisor COuTse id se semester COurse il title dept_name building baulget dept name credits Lid time_slot budlding TOO_rio time_slot_id time slot_i stirt time end_time prereg instructor classroom building neme dept_me capacity teaches salary ID sec semester ver Suppose full name of the instructors are stored as atomic value where parts of names are separated by blank space. Find all instructors who has last name “Rob". (i) (ii) Find the name of those departments whose total salary of the instructors is greater than 600000. (ii) Delete courses having ID beginning with "CS";

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here