Due Week 2 and worth 90 points 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:

The objective of this assignment is to streamline the data processing of an international organization that sells high-end electronics. The organization has various departments including payroll, human resources, finance, marketing, sales, and operations. The sales department is unique because employees are paid a commission in addition to their yearly salary and benefits, whereas all other departments only receive a yearly salary and benefits. The commission for sales employees is calculated by multiplying their commission rate by the total number of product units sold.

To accomplish this task, we have access to several data sets. These data sets are crucial for creating and testing SQL queries to streamline the data processing. The Strayer Oracle Server will be used as the platform for testing and compiling these queries. The login credentials for the Strayer University maintained Oracle server will be provided by the instructor.

In order to assist the organization in streamlining their data processing, several steps need to be taken. Firstly, it is essential to analyze the current data processing system and identify any inefficiencies or bottlenecks. This analysis will help in understanding the existing challenges and areas that require improvement.

Next, we need to design and implement a streamlined data processing system that addresses the identified challenges. This system should be user-friendly and efficient, enabling the organization to handle large volumes of data smoothly.

One crucial aspect of the data processing system is the calculation of commissions for sales employees. In order to calculate the commission accurately, it is necessary to have access to the employee’s commission rate and the total number of product units sold. This data can be obtained from the various data sets available to us.

Once the data processing system is designed, it is important to test and validate its effectiveness. The Oracle server will be used for this purpose, allowing us to test and compile SQL queries to ensure that the system performs as expected.

In conclusion, this assignment presents the opportunity to assist an international organization in streamlining their data processing. By analyzing the current system, designing and implementing a streamlined system, and testing its effectiveness, we can ensure that the organization’s data processing becomes more efficient and effective. The availability of the Strayer Oracle Server and the provided data sets will enable us to test and validate the SQL queries required for this task. By successfully completing this assignment, we can contribute to the organization’s success in the highly competitive electronics market.