Question

Find the titles of courses in the Computer Science department that have 3 credits. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. Find the highest salary of any instructor. Find all instructors earning the highest salary (there may be more than one with the same salary). Find the enrollment of each section that was offered in Fall 2017. Find the maximum enrollment, across all sections, in Fall 2017. Find the sections that had the maximum enrollment in Fall 2017. Increase the salary of each instructor in the Comp. Sci. department by 10%. Delete all courses that have never been offered (that is, do not occur in the section relation) Insert every student whose tot_cred attribute is greater than 100 as an instructor in the same department, with a salary of $10,000

Answer 1

Answer:

Explanation:

To solve this we break down the question and write the programme in steps as shown in the attachment

Download docx