1. Create the following Validation a Make Student Age and GPA Mandatory fields b. Force Major to always display in Upper case letter cAllow only ARTS, BUSINESS and SCIENCE as student Majors d. Change Instructor Kenyon Kunicki to your name and his ID to last 3 digits of your RUID e. (addy feld "tab Fees' to all Courses f. Specify value of Lab Fees should be at least 50.00 but less than $95.00. g. Create a relationship and enforce Referential Integrity to for course maintenance of courses in the School Save the form as YOURNAME Course Form. Include a dropdown list to select i 3. Create and save a query (YOURNAME One Student) ) to display: Student Name Course Name/ and Instructor Name of all courses taken by a stu be design so that when running the query, the Student ID will be used to indicate which student's records will be displayed. 4. Create and save a query(YOURNAME Avg GPA) to display the average GPA of students in each Major. Display only Avg GPA and the Major 5. e a new table, YoURNAME Summary table,listing Student Name, Instructor Name, course title, Grade, and student GPA. All records an must be included. Save All steps used in creating this table. 6. Create and save a Query (YOURNAME Lab fees) to update all Lab Fees to $75.00 for all Computer courses. Computer course IDs are starting with COM. 10 1 Create and save a Query (YOURNAME Students by Instructor) Listing the Number of Students each Instructor is teaching. Display Instructor Name and the number of Students only. 7. 8. Create and Save a query (YOURNAME Student Age) to display student first name, last name and their age.(age must be calculated by th Create and save a report (YOURNAME Details Report) listing: Student Name, Course Name, Instructor Name and Grade. Group the report by Student Major and sort by Student ID within a Course. 9