I need help completing this homework assignment. I have attached the file.

 

MIS562 Week 4 AssignmentsName:_______________________Homework (100 points)Please use the template below to provide your answers.Part 1Using the tables created in Week 2:Question (4 pts. per question)SQL Statement or Answer1.Show a list of all employee names and theirdepartment names and the employees for eachdepartment. Be sure to show all departmentswhether there is an employee in the departmentor not. Use an outer join.2.Select all employee names and their departmentnames. Be sure to show all employees whetherthey are assigned to a department or not. Usean outer join.Using the student schema:Question(3 pts. per question)SQL Statement or Answer3.Write a query that performs an inner join of thegrade, student, and grade_type tables.4.Write a query that performs an inner join of innerjoin of the grade, student, and grade_typetables using the Oracle inner join convention.5.List all of the zip codes in the ZIPCODE tablethat are not used in the STUDENT orINSTRUCTOR tables. Use a set operator.6.Write a SQL statement using a set operator toshow which students enrolled in a section arenot enrolled in any classes. Exclude studentswith a student id less than 300.Part 2Question ( 5 pts. per question)SQL Statement or AnswerPage 1

• 1494231755-MIS562_w4_Homeworkinstructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 08 May 2017 08:05 AM My Price 8.00

-----------

Attachments

file 1494231751-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer