courses queries

[pal]

Hi
This is a database about a college>>

Actually I faced three problems in order to complete the database

The first problem that there are some courses that need 2 prerequisites courses in order the student can take it

Example:
Data Structure & Algorithms course have 2 prerequisites courses
Programming 2 & Discrete Mathematics.
The query only checks one of them.
If the student takes one of them, the query considers that he can take the Data Structure & Algorithms course.

My request is that I need the query to check the both courses in order to let the student take the Data Structure & Algorithms course

The second problem is that there are some courses that doesn’t depend on other courses to be taken, it just need the student to complete a specific credit hours
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.

My request is that I need to check if this student completes the demand hours in order to take these courses in the same query (if that possible)



The last problem is that as you will see I have 2 queries that used to calculate the GPA of the student, depend on the number of the completed hours and the grades for each student.
This query calculates the GPA depends on the grade and if I don’t enter any grade for any course for the student the query will consider the grade F (zero) and will calculate the GPA in wrong way.

My request that I need to make a modification so that if I enter a course for any student I can consider other letter than (A,B+,B,C+,C,D+,D,F) for example N
If I enter N, this course will be calculated in the completed hours but not enter in the GPA calculation.




I add all the courses and the prerequisites so that the db become bigger : )


thanx alot in advance for ur help

 

[MStef]

Hello Pal!
Look at "DemoStudentsCoursesNA2000" (attachment, zip).
First problem, (I didn't work with hours and minutes so far).
1) I added a column "CourseDouble" in the "tblPreriquisite",
also in the "frmPreriquisite".
2) I made a change in the "Query1MakeTable", also
in "qryCoursesSuggest".
3) I made a change in the Module1.
Open MainForm and try.

 

[pal]

Hello

thanx alot sir for your solution for the first problem.
But just i have faced one problem when i add more other courses that are depend on two courses the data will duplicated as you will see in the attachement.In other words the course will appear twice for each student
what can i do??

thanx alot in advance : )

 

[MStef]

I leave a Module1 uncompleted purposely.
Can you complete it yourself.
If you don't know, I'll make it.
Repetitio est mater studiorum.

 

[pal]

Hello sir​

i tryed to complete the module but i couldent since i dont have any background in the module..​

kindly can you help in complete it??​

 

[MStef]

Here it is, (attachment, zip).
Look at Module1.

 

[pal]

Hello

sorry for bing late since i have final exams

Sir i tryed your new db but nothing has changed the problem is same
there are duplicated in the data!!!

i insert other courses that have 2 prerequsits and the same problem happend!!affected other students

look at student "bb"

 

[MStef]

Hello Pal!
1) Why you send me 716 Kb ??
2) Here it is a new one (attachment, zip, 34 kb).
3) I made a NEW "tblNewCoursesB (Index1, Unique = YES, (look at Indexes))
and "qry2NewTblBAppend".
4) I made an annex in the form "MainForm" VBA.
5) I made a changes i "qryCoursesSuggest".
6) I forgot, in "qryCorsesSuggest" you can delete a column "Expr1".

 

[pal]

Hello sir
Really i appriciate your help
Iam thankful for you
your solution is perfect )))

I have one more thing if you solve it you will save my life

i added as you will see 2 more queries that used to calculate the GPA of the student, depend on the number of the completed hours and the grades for each student.
This query calculates the GPA depends on the grade and if I don’t enter any grade for any course for the student the query will consider the grade F (zero) and will calculate the GPA in wrong way.
My request that I need to make a modification so that if I enter a course for any student I can consider other letter than (A,B+,B,C+,C,D+,D,F) for example N
If I enter N, this course will not be calculated in the completed hours and the GPA calculation.


thanx alot sir in advance

 

[MStef]

As I can understand you, in the qry "GPA" put criteria <>"N" in the "Grade" column.