Running head: DATABASE SYSTEMSAssignment 2: Database Systems and Database Models(Students Name)(Professors Name)(Course Title)(Date of Submission)DATABASE SYSTEMS2IntroductionAs a database consultant, I have been hired to assist an international based organizationthat sells high-end electronics in streamlining its data processing. Upon successful completion ofthe task, the high-end electronics store should be able to easily compute the commissions that areto be paid to the sales people. The streamlined data processing will also allow the Company tokeep track of the employees sales as well as their salaries.Query to Determine the Commission paid to a Salesperson for the Month of DecemberThe query below will be used by the finance department to establish the commission thatis to be paid to a particular salesperson in a specific month of the year; in this case, the month ofDecember:SELECT E.EMPNUMBER,EMPFIRSTNAME,EMPLASTNAME,(COMMISSIONRATE * INVAMOUNT) AS COMMISSIONFROM EMPLOYEE E, DEPARTMENT D, INVOICE IWHEREE.DEPARTMENTID = D.DEPARTMENTIDAND E.EMPNUMBER = I.EMPNUMBERAND D.DEPARTMENTDESCRIPTION = 'SALES'AND INVDATE BETWEEN '01-DEC-2013' AND '31-DEC-2013';DATABASE SYSTEMS3Query to Determine Total Compensation for an Employee for the Month of DecemberThe query below will be used to establish the total compensation that will be paid toevery employee for their earnings in the month of December:SELECT E.EMPNUMBER,E.EMPFIRSTNA ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.