Determine the commissions paid to specific employees

Assignment Help Database Management System

Reference no: EM13188699

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.
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.
Describe how Big Data could be used to assist in the productivity and forecasting of the organization's products and resources.

Reference no: EM13188699

Questions Cloud

How did christianity spread in the new latin christendom : How did Christianity spread in the new Latin Christendom? What tools were used by rulers and church officials to spread Christianity. After the fall of the Roman Empire, new Germanic kingdoms arose and became known as Latin Christendom blending Latin..

What is structured programming : What does it mean to say that a programming language is machine independent and name and describe four different programming paradigms.

What are the arguments for using real per capita gni : Among the problems that hinder growth in developing economies are poor infrastructure, lack of financial institutions and a sound money supply, a low saving rate, poor capital base, and lack of foreign exchange. Explain how these problems are inte..

Describe different views of native and euro-american culture : Describe the different views of Native American and Euro-American culture on the intersexed child, or "two-spirit." How have anthropologists in their studies of culture and personality contributed to our understanding of gender roles and personality ..

Determine the commissions paid to specific employees : 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.

What biases or preconceptions did the author reveal : After choosing the topic do the article review which includes following steps a. a short summary that clearly covers all of the fey elements in the article. this summary must show that you carefully read and understood the content of the article.

Impaired depth perception-poor coordination : Impaired depth perception, poor coordination, increased aggression, and poor sexual performance are all symptoms of increased use of?

What is the full path the to location of the web application : what is the full path the to location of the web application directory for the cset-test web application and what is the full path to the main.jsp file for the cset-test web application?

What is the growth rate of its gdp : Suppose an economy's real GDP is $50,000 in year 1 and $55,000 in year 2. What is the growth rate of its GDP Assume that population was 100 in year 1 and 105 in year 2. What is the growth rate in GDP per capita

User Account

All Pages