Hey, currently have a database assignment that I'm struggling with. We are using SQL and we are given certain tables.?
ACADEMIC( acnum , deptnum*, famname, givename, initials, title)
PAPER( panum , title)
AUTHOR( panum*, acnum* )
FIELD( fieldnum , id, title)
INTEREST( fieldnum*, acnum* , descrip)
I've attempted the first one but unsure how correct it is, and the second one had literally no idea. any help would be appreciated
and we have to answer these questions.
Display the given and family names for all academics that are interested in 'Software Engineering'.
SELECT givename, familyname
FROM ACADEMICS, Interest
WHERE acnum = acnum AND description = Software engineering
. List each Field Number and the number of academics interested in each field. Only consider fields listed in the Interest table for this question.