106187 describe hr.employeesTABLE EMPLOYEESColumnNull?EMPLOYEE_IDNOT NULLFIRST_NAMELAST_NAMENOT NULLEMAILNOT NULLPHONE_NUMBERHIRE_DATENOT NULLJOB_IDNOT NULLSALARYTypeNUMBER (6,0)VARCHAR2 (20)VARCHAR2 (25)VARCHAR2(25)VARCHAR2 (20)DATEVARCHAR2(10)NUMBER (8,2) Q2)Create the function Calc_Tax that accept the Employee No and returns his Taxesdue, according to the following formulaSalary >= 1000 tax = 10 % of his salaryotherwise, the Tax = 5% of the salary.Call the function within select statement and take screen shoot of the output.You should use hr.employees table

Note :- You have not mention the language of the program so, I'm answering your question in C++.…

Create the function Calc_Tax that accept the Employee No and returns his Taxes due, according to the following formula Salary >= 1000 tax = 10 % of his salary otherwise, the Tax = 5% of the salary. Call the function within select statement and take screen shoot of the output.

Create the function Calc_Tax that accept the Employee No and returns his Taxes due, according to the following formula Salary >= 1000 tax = 10 % of his salary otherwise, the Tax = 5% of the salary. Call the function within select statement and take screen shoot of the output.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Here are a few small functions for you to work on. You may turn them all in as one submission.…

A: The name of the given function is qdnp. The function is used to convert the money from quarters,…

Q: Create 3 functions: add, multiply, and divide. These 3 functions will accept 2 integer variables as…

A: Top-down Approach: In computer programming, the top-down approach refers to the programming style…

Q: a. The function GET JOB below returns a job title when called. Input and run the function to see how…

A: It is defined as the process that helps to find and perform calculations on specific pieces of data…

Q: Exercise 9: Create a function that takes two arguments and prints out a sentence or word by the…

A: No programming languages mentioned, So I am using python

Q: Create a function called midvalue that accepts three distinct int values as input and returns the…

A: In this task, we will create a function called midvalue that takes three distinct integer values as…

Q: 4. This function takes 2 parameters, your paycheck and the % tax taken out of the paycheck. // 50%…

A: function taxesSuck(paycheck, taxPercent){ var reduced_paycheck =0; var necessities = 0; var…

Q: The arguments of the function take arguments taht reflect the endpoints. Which of the following is…

A: The above question is solved in step 2 :-

Q: Customers can buy computer screens in bulk from Computer Monitor Paradise, Inc. Customers receive…

A: Your python program is given below as you required with an output.

Q: 4. Contoso Workshops Modify the Contoso Workshops assignment from Chapter 3. The modified program…

A: Problem given, Modify the Contoso Workshops assignment from Chapter 3. The modified program takes…

Q: create a function in R studio. function name: df_summary (ex. df_summary(data)) first condition:…

A: Here is the r code of the above problem. See below steps.

Q: we will write a function to compare the suitability of various alien planets for a space colony.…

A: Input: planet_name - The name of the planet entered by the user.Load Data:i) Load the planet data…

Q: 10. Write a complete function. The name of the function is priceGuide, it has a single input…

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

Q: Question 9: Write a function that takes two integer numbers as input and returns the largest of two…

A: In this question we have to program in C++ with a function that takes two integer numbers as input…

Q: In order for a player to navigate your game, you will need to develop a function or functions using…

A: Solution: Given, Show the player the different commands they can enter (such as "go North", "go…

Q: please create a python script for the practice excersie with an explanation. I provided my starter…

A: Algorithm : Step 1 : declare global list to store special characters list. generate_EmailID()…

Q: 2. Create four functions to make a calculator. Each function has two arguments (first number, second…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful. As…

Q: Given helper function: (Hint: This function is to be used to complete the docstring of the function…

Q: Problem II: Define a function named display_tech_store_info that prints information about Gadget…

A: Print "Welcome to Gadget Galaxy!"Print "Visit us at 456 Tech Avenue, Tech City."Create a list of…

Q: Python question please include all steps and screenshot of code. Also please provide a docstring,…

A: The python program is given below:

Question

106
187 describe hr.employees
TABLE EMPLOYEES
Column
Null?
EMPLOYEE_ID
NOT NULL
FIRST_NAME
LAST_NAME
NOT NULL
EMAIL
NOT NULL
PHONE_NUMBER
HIRE_DATE
NOT NULL
JOB_ID
NOT NULL
SALARY
Type
NUMBER (6,0)
VARCHAR2 (20)
VARCHAR2 (25)
VARCHAR2(25)
VARCHAR2 (20)
DATE
VARCHAR2(10)
NUMBER (8,2)

Q2)
Create the function Calc_Tax that accept the Employee No and returns his Taxes
due, according to the following formula
Salary >= 1000 tax = 10 % of his salary
otherwise, the Tax = 5% of the salary.
Call the function within select statement and take screen shoot of the output.
You should use hr.employees table

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

In this coding challenge, you will be retrieving email usernames from a string. You will write a function named get_usernames () that takes in a string as it's input parameter, and returns a list of email usernames in the string. The input strings will contain 0 or more emails in the format and the '@' symbol will only appear in the context of an email. The order of usernames should match the order in the input text. username@domainname, For example: EXAMPLE 1 text: "If you need help on an assignment, email help@ucsd.edu or support@gmail.com" return: ['help', 'support'] EXAMPLE 2 text: "Good morning! I hope you're having a great time with CSE 8A!" return: [] EXAMPLE 3 text: "I've been having a lot of trouble reaching you, can you please email me at cse@ucsd.edu? return: ['cse', 'cse'] Here is the problem description: Function Name: get_usernames Parameter: text - A string corresponding to a piece of text containing 0 or more emails. Return: A list of the email usernames in the input…
Create a function block he garage will accommodate 10 cars.1 The entrance has a momentary limit switch that changes states as a car enters thegarage. This will be simulated by a pushbuttonThe exit has a momentary limit switch that changes states as a car exits thegarage. This switch will be simulated by another pushbutton.The current number of cars in the garage will be indicated on the HMI’snumerical indicator.Also, indicate the number of cars that can still be accommodated. (ex.: if there are3 cars in the garage, indicate that the garage can still accommodate 7 more.)When the system has determined the garage is full a gate will lower, preventingmore cars from entering. A red pilot light will be used to indicate the gate islowered.Provide a message on the HMI stating that the “GARAGE IS FULL”.If the garage is empty indicate that the “GARAGE IS EMPTY” on the HMI andthe counter should be stuck at 0. To reset the system switch is toggled.
The food pantry provides its volunteers with keys to unlock doors and a Food Pantry vest to let customers know they work there. There are a limited amount of keys and vests, so volunteers need to check them out of the office.Complete the program by creating a CheckoutEquipment function that takes in the number of keys and vests currently available at the office. If there are enough keys and vests, the function should reduce the number of keys and vests by 1 and return true. Otherwise, the number of keys and vests will stay the same, and the function will return false. Take note that the number of keys and vests will be defined in the main function and the CheckoutEquipment function should modify the values of those variables declared in main. #include <iostream> int main() { int keys = 10; int vests = 10; bool checked_out = CheckoutEquipment(keys, vests); if (checked_out) { std::cout << "Successfully checked out.\n"; } else { std::cout << "Not…
3. Which among the following shows a valid use of the Direction enumeration as a parameter to the moveCharacter function? Select al that apply. enum Direction { case north, south, west, east}func moveCharacter(x: Int, y: Int, facing: Direction) {// code here} moveCharacter(x: 0, y: 0, facing: .southwest) moveCharacter(x: 0, y: 0, facing: Direction.north) moveCharacter(x: 0, y: 0, facing: .south) moveCharacter(x: 0, y: 0, facing: Direction.northeast)
The term function call refers to running the function. Which lines of code does your group think calls the DonationTimeLeft function? Write the line numbers below.
Python question please include all steps and screenshot of code. Also please provide a docstring, and comments throughout the code, and test the given examples below. Thanks. Write a function diceprob() that takes a possible result r of a roll of pair of dice (i.e. aninteger between 2 and 12) and simulates repeated rolls of a pair of dice until 100 rolls of rhave been obtained. Your function should print how many rolls it took to obtain 100 rollsof r.>>> diceprob(2)It took 4007 rolls to get 100 rolls of 2>>> diceprob(3)It took 1762 rolls to get 100 rolls of 3>>> diceprob(4)It took 1058 rolls to get 100 rolls of 4>>> diceprob(5)It took 1075 rolls to get 100 rolls of 5>>> diceprob(6)It took 760 rolls to get 100 rolls of 6>>> diceprob(7)It took 560 rolls to get 100 rolls of 7
EXCEL VBA (a) Write a user-defined function called SumStop which takes an integer n as an input and adds up the values of the cells in row 1 (starting from cell A1) until the value of the sum exceeds n, and then outputs the number of cells used. You may assume that all of the cells in row 1 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code.
Write a set of functions that calculate the cost of movie tickets for a family. These functions should use a pass-by-reference variable that accesses the double running_total variable in main(). Using a loop, keep displaying the ticket prices for each age group: Something like: Model Hall Movie Ticket Box Office Under Age 3 (free) Ages 3-11 ($10.25) Ages 12-54 ($15.50) Age 55 or older ($12) If 4 tickets are purchased (not counting under age 3) then 20% discount Within the loop: Keep asking the user to input the moviegoer age and to enter a zero for the age when they are finished inputting all the family members. Also, within the loop: Keep a running_total that is output to the screenafter each age has been entered. This running_total should be accessed through the functions using apass-by-reference variable. Finally, after the looping is done: Calculate the total cost, including a 7.5% sales tax, and output it to the screen.
Write the function truck_adjustment_factor(truck_proportion, terrain_type) that takes the proportion of trucks using the motorway and the terrain type as inputs and returns the adjustment factor that is used for calculating the highway capacity. The adjustment factor is calculated according to the following formula: adju stment factor = tprupurtime x(furtor-1) Where proportion is the proportion of trucks and the factor is the car equivalent factor for the given terrain. You should be calling your car_equivalent_factor function to get the factor - don't reinvent the wheel! For example, for rolling terrain and a truck proportion equal to 0.12: adjustment factor = 1/(1 + 0.12 x (4.0 - 1)) = 0.735 Notes: You should include (and call/use) your car_equivalent_factor function in your answer o In general, you should paste in your whole module so far in each question as later functions will call earlier functions. • You can assume the function will always be called with one of the three valid…
Please complete the exercise as instructed and do not use global variables. As well, please follow the guildines of what the solution cannot have in the second image provided. Thank you!