1. Database design:

This database contains three tables: tblStudent, tblCourse, and tblStudentCourse.

tblStudent(StudentID, Sname, GPA)

tblCourse(CourseID, CourseTitle, CreditHour, Description)

tblStudentCourse(StudentID, CourseID, DateTaken, Status)

2. Relationship:

Build relationship

3. Populate the tables with data

4. Create the following queries:

Create a query to display StudentID, SName, GPA, and CourseTitle; and name your query as qryStudentCourse.

Create a query to display SName those who do only a specific CourseTitle.

Create a query to display StudentId, SName and DateTaken

Create a parameterized query to display the Course details by getting the CourseID.

Create a query to display the average GPA of a Course using aggregate function with Group By.

Computer