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 . . .
https://papertowriters.com/wp-content/uploads/2020/07/Writerspng-300x62.png 0 0 admin https://papertowriters.com/wp-content/uploads/2020/07/Writerspng-300x62.png admin2021-11-11 14:28:422021-11-11 14:28:42Microsoft Acces Database (Assignment) Develop a Student Grade Database consisting of the following t