Hi Guys,
Im working with a relational mode;
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, AcNum, Descrip)
Having some problems making some queries for;
Which academics in Victoria have fewer than 2 research interests? Output FAMNAME, GIVENAME,DEPTNUM
You must use NATURAL JOIN.
Among the academics who have no papers, who has the greatest number of interests? List the AcNum,FamName, and GiveName of the academic.
Which academics in the “NLP Research Unit” department have co-authored papers with whom they do notshare an interest? Return their AcNum, FamName and GiveName.
Active researchers are academics who have at least two research interests and have written at least two
papers. Among the departments that have academics, which departments have at least 10 active
researchers? Return their DeptNum and total number of active researchers in descending order.
Help on these queries would be greatly appreciated.
Cheers,
coccoster
Im working with a relational mode;
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, AcNum, Descrip)
Having some problems making some queries for;
Which academics in Victoria have fewer than 2 research interests? Output FAMNAME, GIVENAME,DEPTNUM
You must use NATURAL JOIN.
Among the academics who have no papers, who has the greatest number of interests? List the AcNum,FamName, and GiveName of the academic.
Which academics in the “NLP Research Unit” department have co-authored papers with whom they do notshare an interest? Return their AcNum, FamName and GiveName.
Active researchers are academics who have at least two research interests and have written at least two
papers. Among the departments that have academics, which departments have at least 10 active
researchers? Return their DeptNum and total number of active researchers in descending order.
Help on these queries would be greatly appreciated.
Cheers,
coccoster
