QUESTIONS :

Question 3. SQL In addition to the lecture notes, you should also study by yourself the SOL Plus tutorial on Canvas (the Oracle section) and other resources for Oracle syntax and useful function.s. The ER model for the Academics database is as follows: Department Has Academic Interest Field Author Paper The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC (acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum* acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum* acnumt, descrip) Some notes on the Academics database . An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. * Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR) A research field (FIELD) often attracts many academics and an academic can have interest (INTEREST) in several research fields. Download and run the SQL script academics.sal on Canvas (the Oracle section) to define and populate the Academics database in your Oracle account. Write ONE SQL query for each of questions 3.1--3.9, and each component of an SQL statement must be ona separate line. Your query should not produce duplicates in output but use DISTINCT only if necessary. Include answer for Question 3.10 as comments starting with "- to make the whole SQL script file (.sql) executable (in SQL Developer and other SQL client programs)