Heres a link to the Built Data base http://dcm.uhcl.edu/yue/courses/csci4333/spring2018/HW/c4333u.accdb

(2) Simple Access Query. Use the University DB in Access modified from that of the textbook: c4333u.accdb. Show the screen captures of the query designs. [sample question] The faculty names, the class numbers of the classes they taught, and the students and grades in these classes. Only include faculty that is of the rank Professor. The result: 2cQ2D Note the column label. faculty name classNumber stuld grade S1001 S1002 dam Adams Adams Adams ART103A RT103A ART10 ART103A Adams is the only professor. S1010 faculty class Tracid classNumber name deptCode rank facld schedule room stuld classNumber grade Field: faculty name: name Table: faculty classNumber class grade enroll stuld rank Sort: Ascending Ascending Show Criteria: or. SELECT faculty.name AS [faculty name], class.classNumber, enroll.stuld, enroll.grade FROM faculty INNER JOIN (class INNER JOIN enroll ON class.classNumber enroll.classNumber) ON faculty.facld-class.facld WHERE (((faculty.rank)-'Professor')) ORDER BY faculty.name, class.classNumber, enroll.stuld; (a) Show the faculty id, name, deptCode, rank, and classNumber of classes taught by a Mathematics faculty in the following format. The result: facldnamedeptCode ' F110 F110 F300 rank classNumber Byrne Byrne Winters MATH MATH MATH Assistant Assistant Associate MTH101B MTH103C MTH330A Only Mathematics faculty. Use 'Mathematics' and not 'MATH in your query (b) Show all student ids, names, their majors, and minors in the following format. The result 2010 Note the S015orcaMamampulmeaningful display Computer Science field names Computer Scienceyscs Computer Scence Maketing (c) Repeat (b), except that student names are shown in one field in the following manner Perry Lee dward Bu Owen MicCerthy Mary lones Hatory 1010 51013 Computer Science Computer Science Computer Science So Carol onginio David Computer Science Mathematics Computer Science Computer Science Markecing Student name in one field. (d) Show student ids, class numbers, grades, and instructors of their enrolled courses in the following manner. Only show courses taught by a Mathematics faculty member. Do not use 'MATH in your query. Use 'Mathematics byne Only courses taught by 1020 S1002 51010 S1020 MTH101B MTH203C MTH2030 MTH10 A a Mathematics faculty Do not use 'MATH' in your query (e) Repeat (d), except that the majors of the students are also shown. MTH101B Byrne Computer ScienceMTH1018 MTHIOSC 51002 1010 51020 Byrne Dyrne Computer Science H103C The solutions to Q2 should be put into a single MS words file, with proper description. Name the file: H1 >.docx. Submit your homework through Blackboard (except question 1, in which you need to send an email to the TA.) (2) Simple Access Query. Use the University DB in Access modified from that of the textbook: c4333u.accdb. Show the screen captures of the query designs. [sample question] The faculty names, the class numbers of the classes they taught, and the students and grades in these classes. Only include faculty that is of the rank Professor. The result: 2cQ2D Note the column label. faculty name classNumber stuld grade S1001 S1002 dam Adams Adams Adams ART103A RT103A ART10 ART103A Adams is the only professor. S1010 faculty class Tracid classNumber name deptCode rank facld schedule room stuld classNumber grade Field: faculty name: name Table: faculty classNumber class grade enroll stuld rank Sort: Ascending Ascending Show Criteria: or. SELECT faculty.name AS [faculty name], class.classNumber, enroll.stuld, enroll.grade FROM faculty INNER JOIN (class INNER JOIN enroll ON class.classNumber enroll.classNumber) ON faculty.facld-class.facld WHERE (((faculty.rank)-'Professor')) ORDER BY faculty.name, class.classNumber, enroll.stuld; (a) Show the faculty id, name, deptCode, rank, and classNumber of classes taught by a Mathematics faculty in the following format. The result: facldnamedeptCode ' F110 F110 F300 rank classNumber Byrne Byrne Winters MATH MATH MATH Assistant Assistant Associate MTH101B MTH103C MTH330A Only Mathematics faculty. Use 'Mathematics' and not 'MATH in your query (b) Show all student ids, names, their majors, and minors in the following format. The result 2010 Note the S015orcaMamampulmeaningful display Computer Science field names Computer Scienceyscs Computer Scence Maketing (c) Repeat (b), except that student names are shown in one field in the following manner Perry Lee dward Bu Owen MicCerthy Mary lones Hatory 1010 51013 Computer Science Computer Science Computer Science So Carol onginio David Computer Science Mathematics Computer Science Computer Science Markecing Student name in one field. (d) Show student ids, class numbers, grades, and instructors of their enrolled courses in the following manner. Only show courses taught by a Mathematics faculty member. Do not use 'MATH in your query. Use 'Mathematics byne Only courses taught by 1020 S1002 51010 S1020 MTH101B MTH203C MTH2030 MTH10 A a Mathematics faculty Do not use 'MATH' in your query (e) Repeat (d), except that the majors of the students are also shown. MTH101B Byrne Computer ScienceMTH1018 MTHIOSC 51002 1010 51020 Byrne Dyrne Computer Science H103C The solutions to Q2 should be put into a single MS words file, with proper description. Name the file: H1 >.docx. Submit your homework through Blackboard (except question 1, in which you need to send an email to the TA.)