Question: write a function to calculate and return the amount of a salesman is making his/her commission rate stored in the employee table. HINT: You must

write a function to calculate and return the amount of a salesman is making his/her commission rate stored in the employee table. HINT: You must pass the employee name and sales amount, and the function returns the commission amount calculated based on the commission rate stored table. The table was created using:

CREATE TABLE employee(

empname VARCHAR2(20) PRIMARY KEY

,startdate DATE NO NULL

,commissionrate NUMBER (3,1)

,title VARCHAR2(26)

,manager VARCHAR2(20) REFERENCES employee (empname)

Step by Step Solution

★★★★★

3.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Python import sqlite3 def calculatecommissionempname salesamount Est... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

When sound propagates through a one-dimensional duct and causes all air particles to oscillate around their own equilibrium positions. If we put a plate in one cross-section of the duct and drive the...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Harris Fabrics computes its plantwide predetermined overhead rate annually on the basis of direct labor-hours. At the beginning of the year, it estimated that 40,000 direct labor-hours would be...

CSIS 112: Lab \# 3 WePaintHouses LLC: Employee HR Information Great news! You did such a wonderful job creating the painting estimator program that you have been hired by WePaintHouses LLC ance...

The question SQL Oracle Database : Print the total amount, the average dollar value of service visits (parts and labour costs) and the number of those visits for Acura, Mercedes and Jaguar car makes...

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

1 Instructions - Create a Python file named yourGroupNumberAsg04.py and post it on Canvas. - This is a group assignment. - This assignment's weight is higher: 8% of your grade. - In this assignment...

Java - (Payroll System Modification) Modify the payroll system of Figs. 10.4 10.9 to include an additional Employee subclass PieceWorker that represents an employee whose pay is based on the number...

Modify the payroll system to include an additional Employee subclass PieceWorker that represents an employee whose pay is based on the number of pieces of merchandise produced. Class PieceWorker...

At 30 June, H. Henry has been examining the amounts outstanding from his Accounts Receivable. One account, I. Doubt, owes $1,650 (including GST) but pays only $550 on 30 June, stating that he will be...

Which of the following statements about phases of the Moon aretrue? Select all that apply. at new moon, the Moons entire surface is engulfed indarkness if its new moon, the Moon will rise in the...

Solve the following initial value problem. d v d t = 2 4 t - s e c 2 t , v ( ) = - 6

Able Company manufactures tables for schools. The 2015 operating budget is based on sales of 44,000 units at $55 per table. Operating income is anticipated to be $132,000. Budgeted variable costs are...

The strategy gamut of "international- multidomestic-global-transnational" has prevailed for several years in international business theory. Each archetype speaks directly and differently to how the...

Consider the PLL shown in Figure Q2. Assume that: i) the phase detector is a simple CMOS EXOR whose logic levels are ground and VDD = 5V, ii) both the input to the loop and the VCO output are square...

Write a summary of a science topic of your choice.You must list at least two different types of sources (book, article, report, website, etc.) The quote may be a paraphrase or summary; The direct...

For the second order instrument in problem 4, find M(m) and o (m) for the components of the input signal F(t) =4 sin(2m(0.223)t) sin(27(1)t) + 0.5 sin(2a(1.87)t). What is the resonance frequency of...

Question 1Why is Organizational Behavior considered a hybrid field?It focuses on identifying and utilizing ources of renewable energyAll of theses are trueIt draws insights from many other...

For each of the following situations, indicate whether the taxpayer(s) is (are) required to file a tax return for 2012. Explain your answer. a. Helen is a single taxpayer with interest income in 2012...

Robert Ramos (age 36) is a single taxpayer, living at 8765 Bay Dr., Monterey, CA 93940. His Social Security number is 976-23-5132. Robert's earnings and income tax withholding as the manager of a...

William sold Section 1245 property for $25,000 in 2012. The property cost $35,000 when it was purchased 5 years ago. The depreciation claimed on the property was $16,000. a. Calculate the adjusted...

Jewell and Amie became friends while taking an evening class at the local community college. Jewell was later horrified to find out that Amie was actually a teacher at the college. Subsequently,...

Caleb almost always shows up late for work. His friends attribute this to Calebs laziness. This is an example of a ____ cause. a. situational b. dispositional c. dispensational d. superficial

Stanley Milgrams original study found that _____________ of teachers delivered shocks up to the point of being lethal. a. less than 30 percent b. 40 percent c. 65 percent d. 80 percent