Computer Science Assignment | Custom Assignment Help
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 SQLthat accomplishes the following requirements: – a. "The chair of the Computer Science department is requesting a list of students who havea grade of 85 or better in any computer course. She only wants to see their name once If theyare in the list. ”. Make sure it looks exactly like the example output (at the back of thisassignment). 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 isscheduled to teach”. Make sure it looks exactly like the example output (at the back of thisassignment). Mint: 22 rows returned. Table JOIN or subquery can be used to solve therequirement. 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: 3rows returned. simple query. Table JOIN required. Logic consideration: Aggregate functionand 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 wellas 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) file that executes the required query. Both files onlyz files submitted must be submittedinto 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 file posted. 7. Outputs for each requirement (request) is shown below. Remember, your query shouldgenerate the exact same output (including headers) as shown below. a. Translation:TRANSlATION: CLEANU P:
