Simple queries ?

Question

Hi 


STUDENT, COURSE, GRADE and GRADE_POINT tables presented below .


STUDENT
Primary Key: STUDENT_ID



COURSE
Primary Key: COURSE_NO

GRADE_POINT
Primary Key: GRADE



GRADE
Primary Key: COURSE_NO + STUDENT_ID
Foreign Keys: COURSE_NO references COURSE ,
STUDENT_ID references STUDENT ,
GRADE references GRADE_POINT table



.

1 Retrieve the STUDENT_FNAME and STUDENT_LNAME for all students with CS Major.

2 Retrieve the STUDENT_ID, STUDENT_FNAME , STUDENT_LNAME for all students in CS100.

3 List the first name and last name of all students who have received A in all the courses that they have taken. (Show the query and the result).

4 List the STUDENT_ID, STUDENT_FNAME , STUDENT_LNAME, and GPA for each student. GPA is computed as follows:

GPA = TOT_CR_PT/ TOT_CREDIT, where

TOT_CREDIT is the sum of the credits for all the courses taken by the student

TOT_CR_PT is the sum of [CREDITS]*[POINTS] for all the courses taken by the student, and POINTS is determined by the student's grade in the course.

Thank you everyone