CIS 515 STUDY Future Starts Here/cis515study.com CIS 515 STUDY Future Starts Here/cis515study.com | Page 5

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,
Department, and Job) in order to compare and validate your code.
Validated query code must be part of your paper.
Compare the code of the query you designed in Question one (1) to
one that would show how much total compensation is paid to each
employee for the same month.
Determine and explain the factors necessary to ensure referential
integrity.
Create an object-oriented model to show how the tables are
interrelated through the use of graphical tools such as Microsoft