MIS562 WEEK 4 QUESTIONS AND SOLUTION - 42365

Solution Posted by
krock7714

krock7714

Rating : No Rating
Solution Detail
Price: $10.00
Request Description

 

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.

 

Solution Description

ATTACHED ARE THE SC

Attachments
MIS562 WEEK 4.zip
MIS562 WEEK 4.z...