Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. a. List the deptnum and total number of academics for CS departments, in alphabetical order of deptname. CS departments are departments whose deptname contains
1. a.
List the deptnum and total number of academics for CS departments, in alphabetical order of deptname. CS departments are departments whose deptname contains the phrase "Computer ... Science" or Computing Science in upper case or lower case letters. You must use the NATURAL JOIN operator.
b.
Return the research interest that has the largest number of interested academics. You must not use MAX. Note: An SQL query that lists all research interests in decreasing order of their total number of interested academics is incorrect.?
c.
The relational schema for the Academics database is as follows DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) MIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum_acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum* acnum, 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 in several research fields (INTEREST)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started