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.

If you provide your current solution and what problems you are encountering, you will receive a better response.

This forum is not known for doing your work for you.

I am sorry I was in a hurry and the due date was yesterday, so I could not provide you with any of my solutions.

I was asked to write the query for the following database.

Thanks for your response, I am now done with this work with a friend of mine.
Thanks,
Vivek