These are just the tables..
STU(SSN [pk], Name, Addr) CLASS(Crs_id[pk,fk], Term[pk], Sect[pk], Fac_id[fk])
COURSE(Crs_id[pk], Description)CLASS_TAKEN (Stu_SSN[pk,fk], Crs_id[pk,fk],
FAC(SSN [pk], Name, Dept) Term[pk,fk], Sect[pk,fk], Grade)
CORE_CRS(Crs_id[pk,fk]) * term indicates year(4) & semester(1)
(i.e, 20091 = Sp 2009)
List the names of all faculty members who have taught every course in the
curriculum within the past four years.*
List the name of any students who have not completed all of the core courses with
a "B" or better.