(Solved) : Microsoft Acces Database Assignment Develop Student Grade Database Consisting Following Tw Q30301248 . . . .

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