Microsoft Acces Database "project"

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 two 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 five unique Z numbers for each student. Make up a five digit Course ID for each course. Enter numeric grades for each course taken

Establish a relationship between STUDENT and GRADE using the Z number . Check for referential integrity

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

Save and upload file