Develop a Student Grade Database consisting of the following two tables;
STUDENT
Z number (PK) (Number Field) contains nine digits
Student Name (Text field -25)
College (Text field -3) FAU
Email address (Text field-15)
GRADE
Grade ID auto number
Course ID (Number Field) contains five digits
Course Name (Text-8)
Z number (FK) (Number Field) contains nine digits
Grade (Number) contains three digits
Enter 5 students into the database, each having taken at least three of the following four courses ( ISM 3011, ISM 3116,ISM 4133, ISM 4323). Make up unique Z numbers for each student.Make up a five digit Course ID for each course. Enter numeric grades for each course taken
Generate the following queries:
1. For each course, the lowest, highest and average grade(no decimals)---------COURSE STATS
2. Average grade for each student for all courses taken--------------STUDENT GRADE AVERAGE
3. Student List -----STUDENTS