CIS 515 Course Great Wisdom / tutorialrank.com CIS 515 Course Great Wisdom / tutorialrank.com | Page 4
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
Visio, or an open source alternative such as Dia. Make sure that you
are able to show the relationship types such as 1:M, 1:1, or M:1.
Additionally, remember to include the determined factors from the
previous assignment requirement. Note: The graphically depicted
solution is not included in the required page length.
Identify which data components are the entities and attributes, and the
relationship between each using an object representation diagram
through the use of graphical tools such as Microsoft Visio, or an open
source alternative such as Dia. Note: The graphically depicted
solution is not included in the required page length.