Search results

  1. P

    uncompleted course!

    hello! i have a 3 queries that can offer the courses that the student didnt complete it yet! by check the prereqesit course for it!so the query check if there is grade or just enrolle in that course without grade , it will bs consider as completed course! what i need is to add to the query that...
  2. P

    if function

    hello i want to write if condition in query that use to if the grades of the student A or B+ or B or C+ or C or D+ or D then the completed hours = sum of the course hours OR in other mean if grade Not = "F" then completed hours = sum of the course hours anyone that can help me to...
  3. P

    courses queries

    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...
  4. P

    courses query

    hi everybody i have database about a college and i want to build up a queriy that help me to find out the student who can take a specific coures depend on the pre requisit for the coures (if there is) so the quiry shoud have one input (ID course) and search for the students that can take it...
  5. P

    courses queriey

    hi everybody i have database about a college and i want to build up a queriy that help me to find out the student who can take a specific coures depend on the pre requisit for the coures (if there is) so the quiry shoud have one input (ID course) and search for the students that can take it...
  6. P

    how to calculate the gpa??

    "hi first of all,thanx for your time i build up a database for students in a college %26 i need to calculate the GPA for each one depend on this formula GPA=[(points*no. of cridet hr. for course)+(points*no. of cridet hr. for course)+(points*no. of cridet hr. for course)+.....]/(total...
Back
Top Bottom