Given the relational model below, using your ADU ID and SQL statements.
List all your courses of the last term [0.5 pt.]
List the instructors’ names of these courses in descending order [0.5 pt.]
List all courses of the last term that have no prerequisite [0.5 pt.]
List all courses of the last term with grade above ‘C’ [0.5 pt.]
Determine the CSIT department of the last term courses [1 pt.]
Define the courses of the last term that have more than one section [1 pt.]
Display the sections of the courses above that are offered in your location (‘Abu Dhabi’ or ‘Al-Ain’) [1 pt.]
Please attach your last semester schedule details for crosschecking.
univeristy schema
Answer