Sheet1Sheet2Sheet3AВCDFKTABLE FOR EMPLOYEE SALARY4EMP IDEMP NAMETOTAL SALARY TAX1 TAX2NET SALARYnotes1TAYSEER850tax1 = 10% from total salary6.2SARA45073SAMAH700tax2= 5% from total salary if its <700 and 15% if its >=7008.4МОНАММAD3509.5KHALED1200106ALI100011SAMI6701213MAXIMUM NET SALARY14MINIMUM NET SALARY15insert a chart between EMP NAME and NET SALARYSUM OF THE NET SALARIES16AVERAGE OF THE NET SALARIES17SUM OF THE TOTAL SALARIES18102 3

The given problem is to be solved in Excel using suitable formulas to find the output value for each…

TABLE FOR EMPLOYEE SALARY EMP ID EMP NAME TOTAL SALARY TAX1 TAX2 NET SALARY notes 1 TAYSEER 850 tax1 = 10% from total salary SARA 450 3 SAMAH 700 tax2= 5% from total salary if its <700 and 15% if its >=700 4 МОНАММAD 350 KHALED 1200 ALI 1000 SAMI 670 MAXIMUM NET SALARY MINIMUM NET SALARY insert a chart between EMP NAME and NET SALARY SUM OF THE NET SALARIES AVEDAG E OF TUIE NET SALADIES

TABLE FOR EMPLOYEE SALARY EMP ID EMP NAME TOTAL SALARY TAX1 TAX2 NET SALARY notes 1 TAYSEER 850 tax1 = 10% from total salary SARA 450 3 SAMAH 700 tax2= 5% from total salary if its <700 and 15% if its >=700 4 МОНАММAD 350 KHALED 1200 ALI 1000 SAMI 670 MAXIMUM NET SALARY MINIMUM NET SALARY insert a chart between EMP NAME and NET SALARY SUM OF THE NET SALARIES AVEDAG E OF TUIE NET SALADIES

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter8: Advanced Data Handling Concepts

Section: Chapter Questions

Problem 17RQ

See similar textbooks

Related questions

Q: In cell B10, use a SUMIF formula to calculate the sum of AnnualSales where the value in the Regions…

A: Please refer below for your reference: The B9 value consists of region as NE1 In cell B10 write…

Q: Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from…

A: Sample Response: select Trading_Symbol ,Num_Shares from rows where Selling_Price > Purchase_Price…

Q: ind your group number • The remainder after division of second to last digit of your student id by 3…

A: Required: Find your group number• The remainder after division of second to last digit of your…

Q: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2…

A: GIVEN: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6…

Q: Q :Draw a flow chart for Grade calculation.

A: Flow chart is a pictorial representation of given scenario. Using certain symbols, the flow chart…

Q: Rank Normal forms where each form is a subset of the form above it. [ Select) [Select First Normal…

A: We are going to arrange Normal forms in the database.

Q: explaining why Column chart type selected and why this type was chosen. What is column chart

A: A column chart is a type of chart used to visualize data in the form of vertical columns. Each…

Q: Display the PID and average prices from the PRODUCTS table which price is less than the average…

A: Here we need to perform group by operation in the main query and use Having clause to select only…

Q: Q9) find the least expensive price Q10) List the UNIQUE v_code of vendors that provide products Q11)…

A: A relational database contains tables. Tables are also known as relations and they contain tuples…

Q: E E+TIT T- TXFIF F>(E) la

A: The Answer is

Q: start end 1 8 6

A: -- sql-- select start only if x1 = x2 - 1 is satisfied-- select end as max if x2 = x1 + 1 is…

Q: Question 9 What are the types of the y, z and w? int x = 3; auto y = x; auto&& z = x; auto&& w = 9;

A: What are the types of the y, z and w? int x = 3; auto y = x; auto&& z= x; auto&&…

Q: Select number of movies grouped by year USING MySQL The Movie table has the following columns:…

A: Answer: Given table name is Movie Select statement is used to print the required fields on the…

Q: What does the group by clause accomplish?

A: group by clause is used in relational database with select statement. In select statement group by…

Q: Queries can be used within statement(s): update delete All of the answers Insert

A: A SQL is a Structured Query Language. It uses queries to create database and extract information…

A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…

Q: Assume the PRODUCT table contains multiple rows. The following code would include: SELECT…

A: Dear Student, The answer to your question is given below -

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

Q: The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH…

A: - We need to provide pseudocode for the modes of study for students using FOR-LOOP. - I have…

Q: Employee ID number Employee surname EMPNO Integer Up to 10 characters Integer Integer 7369 SMITH…

A: Given we have to develop a SQL query for the above given scenario:

Q: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is…

Q: Q14) how many products with price < 10

A: You have asked multiple questions so we will solve the first one for you. If you want any other…

Q: The Movie table has the following columns: ID - integer, primary key Title - variable-length string…

A: The select statement is as follows: SELECT Year, Count(*) from movie group by year;

Q: 7. Use the UNION operator to generate a result set consisting of three columns from the Products…

A: The UNION operator in SQL is used to combine the results of two or more SELECT queries into a single…

Q: in a shop ,there are 10 employee and 20 kinds of goods，goods id between 1-20 EMPLOYEE id first…

A: I have to create two separate one for the interactive Start Button and next Step for the columns.…

Q: wrire a select statement to select year and the total numbers of the movie that year by using…

A: Answer starts from step 2

Q: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is…

A: We have a dataset of orders containing order quantities and a corresponding price table. Our task is…

Q: the employee table have the following . ask user what is the employee_id and how much employee…

Q: Q1. Write a SELECT statement that returns these columns from the Invoices table: The invoice _total…

A: The complete answer in SQL query is below:

Q: Subject SubjectNO Student SUB_Name STD_Name Pre SUB STD NO Registration SubjectNO STD NO REG date…

A: A procedure in SQL is a reusable unit that encapsulates the specific business logic of the…

Q: Evaluate the phrase values driven

A: It is a way of big organizations to eveluate their social and community impact. It also aims to…

Q: Calculate count of all the orders. Where Order_ State is Maharashtra Note - Use the alias of oc…

A: Alias is used to give an alias name to a table or a column. Syntax to be used SELECT…

Q: Write the code you would place in the AverageButton click event on your form to call the Average…

A: Program

Concept explainers

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.

Question

100%

Sheet1
Sheet2
Sheet3
A
В
C
D
F
K
TABLE FOR EMPLOYEE SALARY
4
EMP ID
EMP NAME
TOTAL SALARY TAX1 TAX2
NET SALARY
notes
1
TAYSEER
850
tax1 = 10% from total salary
6.
2
SARA
450
7
3
SAMAH
700
tax2= 5% from total salary if its <700 and 15% if its >=700
8.
4
МОНАММAD
350
9.
5
KHALED
1200
10
6
ALI
1000
11
SAMI
670
12
13
MAXIMUM NET SALARY
14
MINIMUM NET SALARY
15
insert a chart between EMP NAME and NET SALARY
SUM OF THE NET SALARIES
16
AVERAGE OF THE NET SALARIES
17
SUM OF THE TOTAL SALARIES
18
10
2 3

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

Introduction

TAX 1

TAX 2

NET SALARY

MIN MAX AVG and SUM as below

VIEW

Chart for NET SALARY and EMP NAME

VIEW

Conclusion

VIEW

Step by step

Solved in 7 steps with 15 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

Consider the following relation: TempID 111 222 333 444 555 666 TempName Joe Mike Sue Pat Bob Joe TemplD JobID J111 J222 J333 J444 J555 J666 TempName TEMP AGENCY Job TypelD T1 T2 T1 JobID T2 T1 T2 Job TypeDesc Bookkeepiing Answering calls Bookkeepiing Answering calls Bookkeepiing Answering calls • Each job has one job type, but multiple jobs can have the same job type • Each job is assigned to one employer. Same employer can have multiple jobs. 5a) In the figure below, indicate functional dependencies by drawing lines with arrows. -| Some of the requirements that this table is based on are as follows: • Each temporary worker has a unique TempID, and a non-unique TempName. • Each employer has a unique EID, and a non-unique EName. • Each job has a unique JobID, and a job type. • Each job type has a unique JobTypeID and a non-unique job type description (JobTypeDesc). • Each temporary worker is assigned to only one job. EID E1 E1 E2 E2 E2 E1 Job TypeID Job TypeDesc Ename Mid Bank Mid Bank…
Design the relation schemes
Give a detailed explaination of the class diagram below
Q_5
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…
Please produce a set of normalized relations for the following statements.
1. Break the table down to 1NF, 2NF anf 3NF.
It has to be based on this table
DATABASE
Guest House Paradiso The Guest House Paradiso used to be a splendid place to stay. But things haven't been updated in a while. Including the way that room bookings are recorded. At the moment they're recorded in a spreadsheet like this: Bookings Table Room Number Number of Nights Arrival Date Departure Date Guest Last Name Guest Phone Number Optional Extras 203 Mar 18 2022 Mar 20 2022 Howard 555-2381 bug-free bed 101 Mar 18 2022 Mar 21 2022 3 Gallagher 555-3619 clean towels, hot water 302 Mar 18 2022 Mar 19 2022 1 Mortimer 555-0856 bug-free bed, clean towels 103 Mar 18 2022 Mar 23 2022 5 McQueen 557-2428 hot water ... 203 Mar 20 2022 Mar 23 2022 3 Carraclough 554-8652 clean towels, hot water Optional Extras There are three types of 'Optional Extras' available in all rooms, and guests can order any combination of these: • hot water • bug-free bed • clean towels NOTE: For this scenario we will assume that a guest's phone number never changes and is unique.
- Find the employee in each department who makes the highest salary in their departments
Tairiq MinesError! Bookmark not defined. Tairiq Mines in Texas has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. 1.Represent the above as a single Entity Relation model. Provide any assumptions necessary to support your model 2.Write an SQL query that displays the parking space number, location as well as the name of the staff member to whom the parking space has been allocated.