0

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.

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by vickyfin
0

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.

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.