Assignment 2- Database Modeling and Normalization

Assignment 2- entropybase role model and Normalization Dr. amir Afzal Strayer University- CIS 515 August 7, 2012 Abstract exchange high end electronics is big championship and being a commissioned employee in that field if your sales ar up means big money. Prices for electronics range from the starting time hundreds into the thousands. It really depends on the person style, specifications they are looking for, trust in the brand, and the judgment of their pockets, how ofttimes a person is instinctive to spend for example on a that high definition led blood plasma television that is 52 inches.No matter the cost, businesses deprivation to keep a track of the sales of their employees and how much they are getting paid. In this case a high-end electronics store wants to streamline data processing to enable them to jockstrap repair the commissions paid to employees. Assignment 2- database Modeling and Normalization Streamlining processes allows education to be getable to users across the governing body. In order for the finance department to be able to visitation across the commission paid to employees reading that maybe held by other departments much(prenominal) as human resources go out be needed.Once the database is complete and has all the breeding such as employee first and last name, employee ID, p.a. salary, commission rate, department, etc, the finance department tummy then being to generate that in numberation. In this case a motion is knowing to allow the finance department to determine commissions paid to employees of specific departments. That computer code leave be compared to the code that would show how much substance compensation is paid to to apiece one employee monthly. Lastly it will be set forth how blown-up Data could be use to assist in productivity and call of organizations product and resources.Methods After information is pull in concert about the employee most of what was mentioned before, and input i nto the system a query back be designed to pull that information from the tables. In order to pull information from tables the portion out character is used to determine the information that is needed and the FROM function tells from what tables to pull it (Coronel, Morris & Rob, 2012). The cryptography that was used to celebrate information on commissions paid to employees was divide Employee. * FROM Employee, Invoice WHERE (DepartmentID =2)The champion next to employees indicates that all the information under the employee table was used to generate the search. In this query information was pulled from the employee and invoice tables. The WHERE function more(prenominal) specifically states the department which can be changed and it would generate new information. The query currently only shows employee commission information for employees who work in department 2 (see attachment). If the finance department wanted to find the total compensation paid to each employee in th e same month as the first query a slenderly different query would be run to generate that information.The first code solely pulled the information and did not include and figuring because the finance department only bespeak to be able to determine as in pull up the leger for employees commission paid. The second code will include computation which will divide the yearly salary by twelve months then multiples the commission rate by the total amount of product sold and lastly add those two numbers together to get the total compensation for that month. Unfortunately the coding that I am using is not generating a proper result.However, it should look something like this SELECT Employee. EmpNumber, Employee. EmpFirstName, Employee. EmpLastName, Employee. YrlySalary, Invoice. InvAmount, Invoice. InvDate, Employee. CommissionRate FROM Employee INNER JOIN Invoice ON Employee. EmpNumber = Invoice. EmpNumber WHERE (DepartmentID=2), it is missing the computation part. Big Data could be us ed to assist in productivity and forecasting of organizations product and resources because it takes thumping pools of data that can be brought together and analyzed to discern patterns and make weaken decisions.It enhances productivity and creates significant value for the dry land economy by reducing waste matter and increasing the quality of products and run (Mcguire, 2012). Additionally, Big Data adds value by fashioning information transparent store more transactional data in digital form, and develop the next generation of products and redevelopments (Mcguire, 2012). That last aspect of Big Data allows manufacturers are using data obtained from sensors infix in products to create innovative after-sales service offerings such as proactive aliment to avoid failures in new products (Mcguire, 2012).References Coronel, C. , Morris, S. , & Rob, P. (2012). Database systems. (10th ed. ). Independence, KY Cengage. Mcguire, T. (2012, July). why big data is the new agonistical advantage. Retrieved from http//www. iveybusinessjournal. com/topics/strategy/why-big-data-is-the-new-competitive-advantage appurtenance A Appendix B