a. "The chair of the Computer Science department is requesting a list of students who have a grade of 85 or better in any computer course. She only wants to see their name once if they are in the list.". Make sure it looks exactly like the example output (at the back of this assignment). Hint: 3 rows returned. Requires multiple table joins.
-b. "The Dean has requested a list of each faculty member and the count of classes each is scheduled to teach". Make sure it looks exactly like the example output (at the back of this assignment). Hint: 22 rows returned. Table JOIN or subquery can be used to solve the requirement. Logic consideration: Grouping data.
-c. "The budget office needs to determine what the total salary is for each faculty rank". Make sure it looks exactly like the example output (at the back of this assignment). Hint: 3 rows returned. Simple query. Table JOIN required. Logic consideration: Aggregate function and grouping data
O O 0 ll Messenger x | (9 Assignmenraazs Fall2018 x D Assignment8326 Fall 2018.}: x G Thebudgetolficeneedsto dei x | u CourseHero x l + e 9 C' (D Filelfi|e:///Users/austi/Downloads/Assignment%208%20326%20Fa||%202018.pdf it 0 Error\" 0 L ,sql file with SQL script that executed the requirements noted below ; The Word document that contains the translation of the requirement to the SELECI' statement that executes the requirements noted below 1. Use the schoolscheduledb database schema 2. Copy this assignment into a Word Document and provide the Translation, Cleanup, and SQL that accomplishes the following requirements: - a. "The chair of the Computer Science department is requesting a list of students who have a grade of 85 or better in any computer course. She only wants to see their name once If they are in the list. \". Make sure it looks exactly like the example output (at the back of this assignment). Hint: 3 rows returned. Requires multiple table joins. -b. \"The Dean has requested a list of each faculty member and the count of classes each is scheduled to teach\". Make sure it looks exactly like the example output (at the back of this assignment). Mint: 22 rows returned. Table JOIN or subquery can be used to solve the requirement. Logic consideration: Grouping data. -e. \"The budget office needs to determine what the total salary is for each [acuity rank\". Make sure it looks exactly like the example output {at the back of this assignment). Hint: 3 rows returned. simple query. Table JOIN required. Logic consideration: Aggregate function and grouping data. 4. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 5. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirement that are provided in the output grid, 6. As noted above, post Mb the Word document with the translation statements and the SQL (sql) le that executes the required query. Both files onlyz les submitted must be submitted into the dropbox by the clue date to receive full credit. Note that the one (1) sql file will have a_l| queries (sol) contained in it. There should n_ot be more than one sql le posted. 7. Outputs for each requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below. a. Translation: TRANSlATION: CLEANU P: f Messenger B Assignment 8 326 Fall 2018 - F X Assignment 8 326 Fall 2018.pd x G The budget office needsto det X *Course Hero X New Tab X + File | file:///Users/austi/Downloads/Assignment%208%20326%20Fall%202018.pdf Error A SQL: b. Translation TRANSLATION: CLEANUP: SQL: c. Translation TRANSLATION: CLEANUP: SQLf Messenger B Assignment 8 326 Fall 2018 - F X Assignment 8 326 Fall 2018.pd x G The budget office needsto dete X *Course Hero X New Tab X + File | file:///Users/austi/Downloads/Assignment%208%20326%20Fall%202018.pdf Error A Result Grid Filter Rows: StudentID Grade StudentFullName 1004 90.56 Galvin, Janice 1011 92.36 Kennedy, John 1016 98.01 P Pundt, Steve Result Grid| Filter Rows: StfFirstName Stflastname ClassCount Alaina Hallmark 8 Alastair Black Ann Patterson Caleb Viescas Carol Viescas David Smith Deb Waldal Gary 10 Hallmark Glynn Result Grid | Filter Rows: Title totalSalary Associate Professor 309000.00 Professor 413000.00 Instructor 503000.00 .....FACULTY...... CLASSES STUDENT_SCHEDULES Stamfic FACULTY_CLASSES Status SUAMID classic Classic SubjectID ClassStatus CPK Tenured ClassRoomit Credits Grade sweet Number StartDate FACULTY SUBJECTS StartTime STUDENTS. ....STAFF....... Duration StaffID StaffID SubjectID CPK MondaySchedule ProficiencyRating StudFirstName StudLasthomo seayschedule StudStreetAddress stastyaddress FridaySchedule StCity Saturdayschedu Stud State StudZipCodef Messenger B Assignment 8 326 Fall 2018 - F X Assignment 8 326 Fall 2018.pd x G The budget office needsto dete X *Course Hero X New Tab X + File | file:///Users/austi/Downloads/Assignment%208%20326%20Fall%202018.pdf Error A Result Grid | Filter Rows: StfFirstName Stflastname ClassCount Alaina Hallmark 8 Alastair Black 6 Ann Patterson Caleb Viescas Carol Viescas David Smith Deb Waldal Hallmark Glynn Result Grid | Filter Rows: Title totalSalary Associate Professor 309000.00 Professor 413000.00 Instructor 503000.00 .....FACULTY...... StaffiD FACULTY_CLASSES CLASSES STUDENT S TheUs StaffID ClassiD classic Tenured ClassID SubjectID Credits SemesterNumber Grade StartDate FACULTY SUBJECTS Stant time STUDENTS .......STAFF....... StaffID SubjectID CPK MondaySchedule StudentiD StaffID ProficiencyHas WednesdaySchedule StudLastName ThursdaySchedule StudLasthanna AStreetAddress attStreetAddress FridaySchedule StudCity SaturdaySchedule Studstate SitzipCode SUBJECTS SttAreaCode SubjectID CLASSROOMS StudPhoneNumber StiPhone Subjectcode ClassRoomID studGender DateHired bunding code theMaritalStatus Position SubjectNa StudMajor Capacity SubjectDescriptions STUDENT CLASS STATUS ClassStatus ClassStatusDescription CATEGORIES BUILDINGS CategoryID BuildingCode DepartmentIn FACULTY CATEGORIES Flovato Access MAJORS `StaffD SiteParkingAvailable CategoryID DEPARTMENTS DeptName DeptChair
