Question: 3. Given a table structure as follows. Studentss Student ID StudFirstName StudLastName PK Course ID CourseName PK IRI Student ID CPKFK Course ID CPKFR Year

 3. Given a table structure as follows. Studentss Student ID StudFirstName

3. Given a table structure as follows. Studentss Student ID StudFirstName StudLastName PK Course ID CourseName PK IRI Student ID CPKFK Course ID CPKFR Year (a) (15 points) Please show the SQL statement that find all courses taken by the student that has student ID-1 and the grades he she receives. The result set should look like: Student ID StudFirstName StudlastName Studlevel Student tD course JD Semester Year Grade Bob Bob Bob Bob Bob Freshman HandersonFreshman Handerson Freshman Handerson Freshman Handerson Freshman Sorina 2015 4 2016 3 Sorina 2016 2 2016 3 Sonina 2014 3 (b) (15 points) Please show the SQL statement that find the GPA for every student. student_id GPA 3.0000 2.7500 3.0000 4.0000 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!