Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics . The organization has various departments such as payroll , human resources , finance , marketing , sales , and operations . The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits . All other departments compensate their employees with a yearly salary and benefits only . Commission is paid by multiplying the employee ’ s commission rate by the total amount of product units sold . You have access to the following data sets :
Employee ( EmpNumber , EmpFirstName , EmpLastName , CommissionRate , YrlySalary , DepartmentID , JobID )
Invoice ( InvNumber , InvDate , EmpNumber , InvAmount ) InvoiceLine ( InvLineNumber , InvNumber , ProductNumber , Quantity ) Product ( ProductNumber , ProductDescription , ProductCost ) Department ( DepartmentID , DepartmentDescription ) Job ( JobID , JobDescription ) Write a two to three ( 2-3 ) page paper in which you :
Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December . Note : You will need to generate the tables described above ( Employee , Invoice , InvoiceLine , Product ,