Create a schema of the db


Discuss the below:

The schema of the DB 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, *AcNum, Descrip)

Q: Which fields have interests shared by academics from the same department? Output the field number, field ID and title, and the total number of academics who have interests.

Attachment:- Academics Database.rar

Solution Preview :

Prepared by a verified Expert
Database Management System: Create a schema of the db
Reference No:- TGS01939027

Now Priced at $25 (50% Discount)

Recommended (95%)

Rated (4.7/5)