View the step-by-step solution to:

MIS562 Week 4 Assignments Name: The problem with not following the submission requirements is extra time required for research, detective work,...

Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join
MIS562 Week 4 Assignments Name: _______________________ Submission Requirements Grading assignments can be a long and lengthy task when the output is not orderly and neat. The problem with not following the submission requirements is extra time required for research, detective work, mistakes in grading, executing queries etc. Accordingly the following requirement should be followed for submitting Assignments. The original problem statements are to be repeated. (With numbers and in order) Penalty - half the point value of the problem statement After the problem statement any student comments can optionally be included. (Example number two and the way the text book inserts comments) Number a penalty The SQL statement as you typed it at the prompt. ( Submit only one, some people include all of their attempts along with errors and retries - that is not acceptable) Penalty for submitting more than one - one quarter the point value of the problem. Penalty for not submitting any, 0 points The result table, in a neat, Readable format. In the case of a very large result table no more than the first 20 rows, with the row number count at the bottom. Penalty -if there is no result table -the full value of the problem is assessed. If there is a table but it is not neat and readable - one half the point value of the problem. If there are more than 20 rows or there is no row count - one quarter of the point value is subtracted. All of the homework submission is to be included in one document and that document is to be sent via the appropriate drop box. ( .txt from notepad is highly recommended). No penalty, the submission will be returned asking that everything be put into one document. I did not used to have this one, so people started driving me nuts and I had to make this rule. Please bear in mind that I hate taking points off because of these issues. I will make every effort in week 1 thread 2 to make certain that everybody can comply with these requirements quickly and easily and painlessly. Failure to adhere to these requirements can result to up to 10% off the total score (one letter grade). The neatness formatting requirements are to demonstrate mastery of the SQL*Plus environment from chapter 2 and the SQL*Plus Guide. Notepad usually works better than WORD in retaining neatness. Page 1
Background image of page 1
Homework (100 points) Please use the template below to provide your answers Part 1 Using the tables created in week 2: Question ( 4 pts per question) SQL Statement or Answer 1. Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join. 2. Select all employee names and their department names. Be sure to show all employees whether they are assigned to a department or not. Use an outer join. Using the student schema: Question ( 3 pts per question) SQL Statement or Answer 3. Write a query that that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax. 4. Write a query that that performs an inner join of inner join of the grade, student, and grade_type tables using the Oracle inner join convention. 5. List all the zip codes in the ZIPCODE table that are not used in the STUDENT or INSTRUCTOR tables. Use a set operator. 6. Write a SQL statement using a set operator to show which students enrolled in a section that are not enrolled in any classes. Exclude students with student id less than 300. Part 2 Question ( 5 pts per question) SQL Statement or Answer
Background image of page 2
Show entire document

This question was asked on Jan 28, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards