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
1.
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
Step by step
Solved in 4 steps
