Question: Consider the database below and answer the query. PK refers to primary key and FK refers to foreign key. Employee( Employee_id(PK) , First_name, Last_name, Email,

Consider the database below and answer the query. PK refers to primary key and FK refers to foreign key.

Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK), Commission_pct, manager_id, department_id(FK))

Departments(Department_id(PK), dept_name, manager_id(FK), location_id)

Locations(Location_id(PK), street_address, postal_code, city, state_province, country_id)

Jobs(Job_id(PK),job_title, min_salary, max_salary)

PL/SQL script to create a function that receives employee ID and commission_pct as arguments and returns the total of salary and commission_pct for that employee, if the commission is more than 0.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

We did not study the Bernoulli distribution in any detail in Section 5.3, because it can be looked upon as a binomial distribution with n = 1. Show that for the Bernoulli distribution, µ'r =...

Did Sanergy make ethical choices? forum The prompt for this discussion forum is "Do you believe that Sanergy made ethical choices? Why do you feel this way?"

5. A woman is saving for retirement in 15 years. She currently has $300,000 in a savings account earning 6% per year. In addition, she is saving $22,000 per year in an account earning 4% per year....

Consider the database below and answer the query. PK refers to primary key and FK refers to foreign key. Employee( Employee_id(PK) , First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK),...

1 . Create a schema employee 2 . Write a SQL statement to create a simple table countries including columns country _ id , country _ name and region _ id . 3 . Write a SQL statement to create a table...

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

DATABASE PROGRAMMING WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS List all the department IDs in the company, and the amount of highest income (salary plus commission_pct * salary), lowest income...

/* 1. Write the SQL to get the Employee Count by Manager. Your results should include the following details: Manager Employee ID Manager Last Name Manager First Name Manager Department Name (not...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

--============================================ /* 1. Write a SQL statement that uses a sub_query. The sub-query should find the employee_ids of managers. The outer query should list all employee...

Lower bound: 18, upper bound: 24 Determine the point estimate of the population mean and margin of error for each condence interval.

Quill Printing allows customers to print their project for a flat fee of $50. However, if a customer prints more than 50 pages, the customer will be charged more in order to cover the costs of the...

Give three examples of marketing you see in your everyday life. Share the marketing element and how it affects you.

A particle moves along the x-axis with the velocity history shown. If the particle is at the position x = 4 in. at time t = 0, plot the corresponding displacement history for the time interval 0 t ...

Use the Laplace transform to solve the given system of differential equations. dx = 4x 2y + 2U(t 1) dt dy = 3x - y + U(t dt U(t x(0) = 0, y(0) =

A small airplane flying horizontally with a speed of 180 mi/hr at an altitude of 400 ft above a remote valley drops an emergency medical package at A. The package has a parachute which deploys at B...

The typical spin lock holds only one bit of data, but requires a full word of storage, because only full words can be read, modified, and written atomically in hardware. Consider, however, the hash...

Your friend who works for the college radio station must make electric-field measurements for a report to be filed with the stations application for license renewal. The measurement is made 4.6km...

i need some help on revising this because i dont know if this is correct Can you determine whether a change control process was used? Based on earlier discussion, I've chosen the outages involving...

Suppose you work for the university and have access to student, class, professor, department, and grade data. Assume the student data includes students home address, high school, and prior...

1. What implications WiMax have for existing established traditional telephone companies. 2. Beyond television, what other new capabilities could be enabled by this technological innovation? 3. What...

Singing Valley Resort is a top-end (rooms cost from $400 to $2500 per night), 50-unit resort located high in the mountains of Colorado. Singing Valley prides itself on its beautiful location, its...

Reported below are the amounts spent on advertising ($ millions) by a large firm from 2004 to 2014. a. Determine the logarithmic trend equation. b. Estimate the advertising expenses for 2017. c. By...

Listed below are the net sales (in millions of euros) for the Adidas Group from 2008 to 2012. Year Net Sales 2008 ........ 10,799 2009 ........ 10,381 2010 ........ 11,990 2011 ........ 13,332 2012...

Sams Supermarkets tests its checkout clerks by randomly examining the printout receipts for scanning errors. The following numbers are the number of errors on each receipt for October 27: 0, 1, 1, 0,...