hi everybody

i have database about a college and i have a query that help me to find out the student who can take a specific coures depend on the pre requisit for the coures

just i need additional thing to add for the query .
There are some courses that dosent depend on other courses to be taken
it just need the student to complete a specific cridet houres
to be taken
the courses are the following:
101408 Ethical Aspects of Eng. & CS >70 hrs.
101461 IT/ Marketing Research >70 hrs.
101490 Computer Software Lab >70 hrs.

101493 CS Seminar >80 hrs.
101494 Senior Project I >80 hrs.
101495 Training >80 hrs.

102594 Senior Project I >100 hrs.


102595 Training >100 hrs.
102493 CE Seminar >100 hrs.

so i need to ckech if this student complete the demand hours inorder to
take this courses in the same query(if that possible)

thanx alot in advance for ur help


the database consist from this tables:
*courses
contain the courses of the college
*prereqisit
contain the prerequisit courses
*students
information about the students
*enrolment
contain the courses that the students have it
*department
contain the departments of the colleges

here is the link for the db

http://uu4.com/upload/download.php?id=389