Final Exam Fall 2016 The due date for the Final Exam is 12/12/2016 11:59 pm. It must be submitted through the "Final Exam" in Dropbox provided in the...
Hello Can someone please assist with the attached. Must be done with My SQL. Only 14 questions need to be answered, please indicate which questions. Thank you.
Final ExamFall 2016The due date for the Final Exam is 12/12/2016 11:59 pm. It must be submitted through the “FinalExam” in Dropbox provided in the eCollege. It is opened-book, opened-note, opened-Internet, but notopened-friends or neighbor. It means that you have to do this exam by your own. You can use Internetto check your syntax, but cannot ask anyone to do the exam for you. If the final exam is not done byyou, you will get 0.It is important that you specify your name in the assignment document/attachment. The attachmentname should follow the following convention: BUSA526_FINALEXAM_FIRSTNAME_LASTNAME.SQLImport the final exam data code and use the following logical schema to answer only 14 questionsbelow. Note: I only grade your first 14 questions, and there is no bonus if you answer all questions. Also,make sure to leave comments/notes for me to know which questions you want to address. Allquestions have to be answered within one SQL command. (100 points total: 7 points each question,and free 2 points for everyone). 1. Show student first name, last name, major, and full address (return total 4 columns)2. Show staff first name, last name, and salary of who get hired after Dec 1992 (return total 3columns)3. Display subject, department name which offers that subject, category of that subject, andprofessor’s first name and last name who taught that subject (return total 5 columns)4. Show student first name, last name, major, and month of birth in alphabet (return total 4columns). Must use techniques taught in class. No credit given if you use advanced techniques.5. Show all information of professor who taught the most classes.6. Select staff first name, last name, salary, and total commission received (return total 4 columns).Each staff get $3000 commission for one class he/she taught.7. What is the most popular major?8. Select all information of class(es) that has the top 2 highest numbers of students. Must usetechniques taught in class. No credit given if you use advanced techniques (e.g, LIMIT).9. Show all info of female students who took more morning Monday class(es) than afternoonMonday class(es).10. Return student first name, last name, his/her second highest grade, and subject of the class thathe/she earned (return total 4 columns). Must use techniques taught in class. No credit given ifyou use advanced techniques (e.g, LIMIT).11. Do we have more students who are single than who are married? Must return ‘Yes’ or ‘No’.12. For each students, display currently taking classes that has the latest start time.13. Find the most common subject(s) that are taken by students14. Who is/are professor(s) the most recent hired? Must use techniques taught in class. No creditgiven if you use advanced techniques.15. Find classroom(s) that do not fill out half of its capacity per classes.16. Find student(s) who got highest GPA for each classes. Must indicate ‘Best Student’ in one of thereturned columns for that student(s) The following criteria will be used to grade the midterm: Diagrams are detailed, accurate, and SQL answers are correct. ***************************NOTE *************************************Please feel free to consult your instructor by email or phone, if you have questions or need assistance!!
Show more
