Database Systems and Database Models

Imagin" rel="nofollow">ine that you have been hired as a consultant to assist in" rel="nofollow">in streamlin" rel="nofollow">inin" rel="nofollow">ing the data processin" rel="nofollow">ing of an in" rel="nofollow">international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, fin" rel="nofollow">inance, marketin" rel="nofollow">ing, sales, and operations. The sales department is the only department where employees are paid a commission in" rel="nofollow">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 multiplyin" rel="nofollow">ing the employee's commission rate by the total amount of product units sold. You have access to the followin" rel="nofollow">ing data sets: -Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentlD, JobID) -Invoice (InvNumber, InvDate, EmpNumber, InvAmount) -InvoiceLin" rel="nofollow">ine (InvLin" rel="nofollow">ineNumber, InvNumber, ProductNumber, Quantity) -Product (ProductNumber, ProductDescription, ProductCost) -Department (DepartmentID, DepartmentDescription) -Job (JobID, JobDescription)Write a two to three (2-3) page paper in" rel="nofollow">in which you: 1.Design a query that will allow the fin" rel="nofollow">inance department to determin" rel="nofollow">ine the commissions paid to specific employees of the sales department for the month of December. 2.Compare the code of the query you designed in" rel="nofollow">in Question one (1) to one that would show how much total compensation is paid to each employee for the same month. 3.Determin" rel="nofollow">ine and explain" rel="nofollow">in the factors necessary to ensure referential in" rel="nofollow">integrity . 4.Create an object-oriented model to show how the tables are in" rel="nofollow">interrelated through the use of graphical tools. 5.Identify which data components are the entities and attributes, and the relationship between each usin" rel="nofollow">ing an object representation diagram through the use of graphical tools. Note: The graphically depicted solution is not in" rel="nofollow">included in" rel="nofollow">in the required page length. 6.Describe how Big Data could be used to assist in" rel="nofollow">in the productivity and forecastin" rel="nofollow">ing of the organization's products and resources. Include charts or diagrams created in" rel="nofollow">in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice.