Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

I need help with my MIS 582 class assignment

/in /by

I need help with my MIS 582 class assignment. I have to write 10  SQL queries. I have done the first 3 queries,

but I am have trouble with the remaining queries. I have included the table, script and screen shots of where I am currently stuck. My assignment is due 5/18 @ 10 pm. Is there someone available that can help me?

 ATTACHMENT PREVIEW Download attachmentMIS582 COURSE PROJECTThe Course Project will consist of three tasks, each worth 50 points due in Weeks 2, 4, and 6. Successfulcompletion of the iLabs will help you in completing the project tasks.Week 2: Task1:SQL Queries Using MySQL (50 Points)Using the same tables that you created by running the script file provided in Doc Sharing for iLab1, writethe following 10 queries each worth 5 points.NameTaskQuery1Write a SQL statement to display the course numbers of classestaught by Hammett Glenn.Query2Write a SQL statement to display the course names of thecourses taught by an instructor whose id is 415.Query3Write a query to display the name and office number of allinstructors who teach Psy101.(USE NATURAL JOIN)Query4Write a query to display the semester and the number of coursesoffered in that semester. Display only the semesters that offermore than five courses.Query5Write a SQL statement to display the name of each campus andthe total number of rooms in that campus.Query6Write a SQL statement to display the list of instructors who areapproved as well as those who are not approved. (OUTERJOIN)Query7Write a SQL statement to display the start date and start time ofall classes taught by instructor Hammett Glenn.Query8Write a SQL statement to display the number of students ineach major with a status of failing.Query9Write a SQL statement to display the credit hours of all coursesthat Hammett Glenn is approved to teach.Query10Get the campus name and phone number of all rooms withnumbers greater than 25.DeliverablesCreate and save your SQL queries and script in a text file namedLastname_Task1_SQL_Script.sql.Capture the output and paste it into Word Document. Save it asLastname_Task1_SQL_Result.txt.When you are done, submit your documents zipped together in a single file to theWeek 2:Course Project Week 2 Task 1 Dropbox.

Background image of page 1

View the AnswerRubricsQueries that are correct will be awarded the number of points shown below:4 points:Query 15 points:Query 2–96 points:Query 10The following rubrics will be used for incorrect queries.0 points: Query was not turned in with the assignment.-4 points: Query will not run.-3 points: Query runs but is incorrect because query required a WHERE clause to meetrequirements which was not included.-2 points: Query runs but is incorrect because the WHERE clause contained errors, gives popupfor user input, or only meets partial requirements.Tutorials to Consult WithM10C_KROE8352_13_SE_WC10C.pdfin the folder Ttled My SQL Documents in Doc Sharing for all thingsto do with MySQL including example SQL.Login MySQL Omnymbus Environment.docxin the folder Ttled Omnymbus ±utorial Files in Doc Sharingfor how to log into the Omnymbus Environment.CreaTng a Database in MySQL Omnymbus Environment.docxin the folder Ttled Omnymbus ±utorialFiles in Doc Sharing for how to create a Database in the Omnymbus Environment. Remember, all workmust be done under a database you ²rst create.Running SQL Scripts in MySQL Omnymbus Environment.docxin the folder Ttled Omnymbus ±utorialFiles in Doc Sharing for how to create and run your SQL Scripts.

Background image of page 2
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"