The  Strayer Oracle Server may be used to test and compile the SQL Queries  developed for this assignment. Your instructor will provide 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: Write a two to three (2-3) page paper in which you: Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Purchase the answer to view it Purchase the answer to view it

The task at hand requires streamlining the data processing of an international organization that sells high-end electronics. This organization has several departments, such as payroll, human resources, finance, marketing, sales, and operations. Among these, the sales department is unique because employees receive a commission in addition to their salary and benefits.

To tackle this assignment, we have access to various data sets. The first data set provided is the “employees” table, which contains the following columns: EmployeeID, LastName, FirstName, DepartmentID, CommissionRate, Salary, and Benefits. Each row in this table represents an employee in the organization. The EmployeeID is a unique identifier for each employee, while the LastName and FirstName columns contain the employee’s last and first names, respectively. The DepartmentID column indicates which department the employee belongs to, and the CommissionRate column represents the percentage commission rate for that employee. The Salary column contains the yearly salary for the employee, and the Benefits column specifies the benefits package provided to the employee.

The second data set is the “products” table, which includes the following columns: ProductID, ProductName, and UnitPrice. This table lists all the products that the organization sells. Each row represents a different product, with the ProductID serving as a unique identifier. The ProductName column contains the name of the product, and the UnitPrice column specifies the price of a single unit of that product.

Finally, we have the “sales” table, which consists of the following columns: InvoiceID, EmployeeID, ProductID, and QuantitySold. This table tracks the sales made by each employee. The InvoiceID column serves as a unique identifier for each sale, while the EmployeeID column links the sale to the employee who made it. The ProductID column associates the sale with the specific product that was sold, and the QuantitySold column indicates how many units of that product were sold in that transaction.

To streamline the data processing for this organization, we need to retrieve specific information from these data sets. One of the key tasks is to calculate the total commission earned by each sales employee. This can be done by multiplying the commission rate of each employee by the total quantity of products they have sold. Additionally, we may need to calculate the total sales revenue for the organization, which can be obtained by summing the total price of the products sold in each transaction. Analyzing this information can provide valuable insights into the performance of the sales department and assist in identifying areas for improvement.

In conclusion, this assignment requires us to optimize the data processing for an international organization that sells high-end electronics. By utilizing the provided data sets, we can calculate the commission earned by sales employees and analyze the sales performance of the organization. These insights can help streamline operations and improve overall efficiency.