Member Avatar for vickyfin

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
  • 138 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by vickyfin
Member Avatar for Stylish

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.

Member Avatar for vickyfin

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.