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

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: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: To complete the `SELECT` statement to select the year and the average price of books for that year,…

Q: Complete the following statement to create a table named Country. Choose data types based on the…

A: The question is asking to create a SQL table named 'Country' with two columns: 'ISOCode3' and…

Q: List the first name and last name of all authors. Concatenate the first and last names so that the…

A: Concat() function : This function in SQL joins string into one, maximum string which it can take as…

Q: Show students’ first name, last name, the grades of the students, and the credits of the course for…

A: Select St.FristName, St.LastName, Et.Grade, C.CourseIDfrom Student St INNER JOIN Enrollment Et ON…

Q: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: The question is asking for a SQL query that will return each genre and the total number of books in…

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel…

A: Normalization which refers to the one it is the process of organizing data in a database in order to…

Q: Show all female’s first names and their salary. Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: The expression =IF(A1 > 8, 12*A1, 7*A1) is used in a spreadsheet. Find the result if A1 is 5 Find…

A: We have expression IF(A1>8, 12*A1, 7*A1) When A1>8, then the result = 12*A1 Else A1≤8 then the…

Q: Question 1 Use Index and math functions to fill in a table that extracts the amounts shipped…

A: The task at hand involves using Excel's Index and math functions to populate a table displaying the…

Q: Write the Excel function to determine the number of salespersons who had a Sales Total above the…

A: use countif function to apply condition in given range countif syntax:- countif(range,criteria)…

Q: Complete the following statement to create a table named Country. Choose data types based on the…

A: The question is asking to create a SQL table named 'Country' with two columns: 'ISOCode3' and…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

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: Below are some rows of the PROVIDERS table for a factory: PCODE NAME PHONE 10192 Hans, Inc.…

A: In this casе, wе arе working with a "PROVIDERS" tablе for a factory, and thе goal is to rеtriеvе…

Q: For this portion of the lab design the solution in the following manner: Create a table using a…

A: Program Explanation: Define the function for conversion. Inside the function create the table for…

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

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
in a shop ,there are 10 employee and 20 kinds of goods，goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?
the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id &contribution_amount If employee salary is in between $1000-$3999 And if employee's contribution amount is less than $100 then company match $100 if employee's contribution amount is greater than 100 but less than $200 then company match $75 if employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if employee's contribution amount is less than $100 then company match $150 if employee's contribution amount is greater than 100 but less than $200 then company match $100 if employee's contribution amount is greater than $200 then company match $75 $7000-$12000And if employee's contribution amount is less than $100 then company match $200 if employee's contribution amount is greater than…
Assume the PRODUCT table contains multiple rows. The following code would include: SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_CODE IN(SELECT P_CODE FROM LINE GROUP BY P_CODE HAVING COUNT(*) > 1); Group of answer choices A) Select the products that have been ordered before. B) Select the products that have been ordered at least once. C) Select the products that have been ordered at least twice. D) An error message.
Select "Patent Number Search" for patents. Give the title or brief description for each of the following patents, identify when they will expire, and provide the due dates for any maintenance payments related to the patents. a. Utility Patent No. 9,089, 123. p. Design Patent No. D488,590 E. Plant Patent No. 12, 144 d. Reissue Patent No. 42,997
List the name of each department, and its total number of employees, and the total amount of salaries