Queries on multiple tables
Before you do this assignment - make sure that you have gotten the
student database back and have made any corrections that will make
it work more effectively.
Please number your queries 1, 2, 3, 4, 5 to match the questions.
- Write a query using the query user interface that will display
the student id, student name, student major, course id number for each
course the student is taking.
- Write a query using the query user interface that will display
the student id, student name, student major, course id number fo each course
the student is taking, course name for each course the student is taking,
number of credits for the course.
- Write a query using the query user interface that will display
a course id, a course name and the student id number and student
name for each student taking the course.
- Write a query using the query user interface that will display
student id number, student name, student major, student GPA and
course id number for each course the student is taking for students
who are CI majors and have a GPA greater than 3. If you used a different
major code than CI, you can substitute your code in this query.
- Make up a query using three tables where you only show students
that meet criteria in an OR relationship. The query above showed only
students in an AND relationship when I asked about CI majors and GPA > 3.