CIS 515 STUDY Learn Do Live /cis515study.com CIS 515 STUDY Learn Do Live /cis515study.com | Page 4

you with login credentials to a Strayer University maintained Oracle
server.
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 departmen t for the
month of December. Note: You will need to generate the tables
described above (Employee, Invoice, InvoiceLine, Product,