year of service benefits مخص صك سنوت الخدمة acadmaic degree place of residence year ef service basic salary transfer benefits certificate benefits total salary Employeeid 1 2 E123 Bochelor incity outcity incity outcity incity incity outcity 10 ? ? ? 3 E234 diploma 12 ? ? ? 4 E124 none ? ? ? ? E453 none 25 ? ? ? ? ? E222 E341 E412 6 Bochelor 13 ? ? ? 7 30 26 ? ? ? ? diploma Bochelor 8 ? ? ? ? 9 10 find the number of employees that residence incity and have [10.30] year of service 11 find the number of employees that "diplpma" acadmaic degree and "bochalor" acadmaic degree 12 find the average of the omployess basic salay that residence outcity and have none acadmaic degree with ca10 year of serviceon 13 find the sum of total salary for employees that have (20.30) year of service and have Bochelor acadmaic degreen 1- Find the basic salary for each employee, which depending on the academic degree as fallow: Bachelor > 7502. , Diploma > 600 2. , None > 300 e 2- Find the transfer benefits for each employee, which depending on place of residence as fallow: Incity 20g3, Outcity 40 3- Find the certificate benefits for each employee, which depending on the academic degree and basic salary as fallow: Bachelor > 20% from the basic salary , Diploma → 10% from the basic salary, none → 5% from the basic salary 4- Find the year of service benefits for each employee, which depending on the year of service as fallow: [1:10] → 50 E. uI11:20] →100 g., [21:30] → 200 g., >= 31 300g. 5- Find the total salary for each employee as fallow: Total salary = basic salary + transfer benefits + certificate benefit + year of service benefit 6- Find the number of employees that residence incity and have [10:30] year of service 7- Find the number of employees that "diploma" academic degree and "bachelor" academic degree = 8- Find the average of the employees basic salary that residence outcity and have none academic degree with <=10 year of service= 9- Find the sum of total salary for employees that have [20:30) year of service and have Bachelor academic degree=
year of service benefits مخص صك سنوت الخدمة acadmaic degree place of residence year ef service basic salary transfer benefits certificate benefits total salary Employeeid 1 2 E123 Bochelor incity outcity incity outcity incity incity outcity 10 ? ? ? 3 E234 diploma 12 ? ? ? 4 E124 none ? ? ? ? E453 none 25 ? ? ? ? ? E222 E341 E412 6 Bochelor 13 ? ? ? 7 30 26 ? ? ? ? diploma Bochelor 8 ? ? ? ? 9 10 find the number of employees that residence incity and have [10.30] year of service 11 find the number of employees that "diplpma" acadmaic degree and "bochalor" acadmaic degree 12 find the average of the omployess basic salay that residence outcity and have none acadmaic degree with ca10 year of serviceon 13 find the sum of total salary for employees that have (20.30) year of service and have Bochelor acadmaic degreen 1- Find the basic salary for each employee, which depending on the academic degree as fallow: Bachelor > 7502. , Diploma > 600 2. , None > 300 e 2- Find the transfer benefits for each employee, which depending on place of residence as fallow: Incity 20g3, Outcity 40 3- Find the certificate benefits for each employee, which depending on the academic degree and basic salary as fallow: Bachelor > 20% from the basic salary , Diploma → 10% from the basic salary, none → 5% from the basic salary 4- Find the year of service benefits for each employee, which depending on the year of service as fallow: [1:10] → 50 E. uI11:20] →100 g., [21:30] → 200 g., >= 31 300g. 5- Find the total salary for each employee as fallow: Total salary = basic salary + transfer benefits + certificate benefit + year of service benefit 6- Find the number of employees that residence incity and have [10:30] year of service 7- Find the number of employees that "diploma" academic degree and "bachelor" academic degree = 8- Find the average of the employees basic salary that residence outcity and have none academic degree with <=10 year of service= 9- Find the sum of total salary for employees that have [20:30) year of service and have Bachelor academic degree=
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
I need the answer as soon as possible
![A
C
E
F
year of service
benefits
مخصصات سنوات الخدعة
acadmaic degree
place of residence year of service basic salary transfer benefits certificate benefits
total salary
Employee-id
1
2
E123
Bochelor
incity
outcity
incity
outcity
incity
incity
outcity
10
?
?
?
?
?
3
E234
diploma
12
?
?
?
?
?
4
E124
none
?
?
?
?
?
5
E453
25
?
?
?
none
Bochelor
6
E222
13
?
?
?
?
?
7
E341
diploma
Bochelor
30
?
?
?
?
8
E412
26
?
?
?
9
10 find the number of employees that residence incity and have [10.30] year of service =
11 find the number of employees that "diplpma" acadmaic degree and "bochelor" acadmaic degree =
12 find the average of the employess basic salay that residence outcity and have none acadmaic degree with <=10 year of service=
13 find the sum of total salary for omployees that have (20.30) yoar of service and have Bochelor acadmaic degroe=
?
?
?
1- Find the basic salary for each employee, which depending on the academic degree as fallow:
Bachelor → 750 E. , Diploma > 600 2 , None > 300 E.
2- Find the transfer benefits for each employee, which depending on place of residence as fallow:
Incity > 2023 , Outcity > 40 g.
3- Find the certificate benefits for each employee, which depending on the academic degree and basic salary as
fallow:
Bachelor > 20% from the basic salary , Diploma → 10% from the basic salary, none > 5% from the basic salary
4- Find the year of service benefits for each employee, which depending on the year of service as fallow:
[1:10] → 50 E. uI11:20] →100 g., [21:30] → 200 E., >= 31 → 300 2.
5- Find the total salary for each employee as fallow:
Total salary = basic salary + transfer benefits + certificate benefit + year of service benefit
6- Find the number of employees that residence incity and have [10:30] year of service
7- Find the number of employees that "diploma" academic degree and "bachelor" academic degree =
8- Find the average of the employees basic salary that residence outcity and have none academic degree with <=10
year of service=
9- Find the sum of total salary for employees that have [20:30) year of service and have Bachelor academic degree=](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F60e5e02f-952b-4051-8cc7-cb37d63272c4%2F835b2cdf-52e4-4804-9610-b773e0dcd327%2Fsb2r90g_processed.jpeg&w=3840&q=75)
Transcribed Image Text:A
C
E
F
year of service
benefits
مخصصات سنوات الخدعة
acadmaic degree
place of residence year of service basic salary transfer benefits certificate benefits
total salary
Employee-id
1
2
E123
Bochelor
incity
outcity
incity
outcity
incity
incity
outcity
10
?
?
?
?
?
3
E234
diploma
12
?
?
?
?
?
4
E124
none
?
?
?
?
?
5
E453
25
?
?
?
none
Bochelor
6
E222
13
?
?
?
?
?
7
E341
diploma
Bochelor
30
?
?
?
?
8
E412
26
?
?
?
9
10 find the number of employees that residence incity and have [10.30] year of service =
11 find the number of employees that "diplpma" acadmaic degree and "bochelor" acadmaic degree =
12 find the average of the employess basic salay that residence outcity and have none acadmaic degree with <=10 year of service=
13 find the sum of total salary for omployees that have (20.30) yoar of service and have Bochelor acadmaic degroe=
?
?
?
1- Find the basic salary for each employee, which depending on the academic degree as fallow:
Bachelor → 750 E. , Diploma > 600 2 , None > 300 E.
2- Find the transfer benefits for each employee, which depending on place of residence as fallow:
Incity > 2023 , Outcity > 40 g.
3- Find the certificate benefits for each employee, which depending on the academic degree and basic salary as
fallow:
Bachelor > 20% from the basic salary , Diploma → 10% from the basic salary, none > 5% from the basic salary
4- Find the year of service benefits for each employee, which depending on the year of service as fallow:
[1:10] → 50 E. uI11:20] →100 g., [21:30] → 200 E., >= 31 → 300 2.
5- Find the total salary for each employee as fallow:
Total salary = basic salary + transfer benefits + certificate benefit + year of service benefit
6- Find the number of employees that residence incity and have [10:30] year of service
7- Find the number of employees that "diploma" academic degree and "bachelor" academic degree =
8- Find the average of the employees basic salary that residence outcity and have none academic degree with <=10
year of service=
9- Find the sum of total salary for employees that have [20:30) year of service and have Bachelor academic degree=
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY