Microsoft Acces Database (Assignment) Develop a Student Grade Database consisting of the following twotables; STUDENT              Z number  (PK)                          (Number Field)    contains nine digits              StudentName                           (Text field -25)              College                                       (Textfield -3)     FAU              Emailaddress                            (Text field-15) GRADE             GradeID                                  auto number             CourseID                                (NumberField) contains five digits                CourseName                          (Text-8)              Z number (FK)                         (NumberField)    contains nine digits              Grade                                      (Number)     contains two digits Enter 5 students into the database, each having taken at leastthree of the following four courses ( ISM 3011, ISM 3116,ISM 4133,ISM 4323). Make up five unique Z numbers for each student. Make upa five digit Course ID for each course. Enter numeric grades foreach course taken Establish a relationship between STUDENT and GRADE using the Znumber . Check for referential integrity Generate the following queries: 1.       For each course, thelowest, highest and average grade(no decimals)———COURSESTATS 2.       Average grade for eachstudent for all courses taken————–STUDENT GRADEAVERAGE 3.       Student List—–STUDENTS Save and upload file . . .

"Get 15% discount on your first 3 orders with us"
Use the following coupon

Order Now