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,