d. Write the sql command for Updating the contract column for all employees, who's job- "1 id is dir.man as 1 year". Write the sql command for Updating the contract column for all employees, who's job- id is ceo as "4 years". Mr William has been been promoted as an operational management with job-id of "oper_man" with salary of (10000). Write the sql commands that will update mr William record according to the promotion her received. e. f.
d. Write the sql command for Updating the contract column for all employees, who's job- "1 id is dir.man as 1 year". Write the sql command for Updating the contract column for all employees, who's job- id is ceo as "4 years". Mr William has been been promoted as an operational management with job-id of "oper_man" with salary of (10000). Write the sql commands that will update mr William record according to the promotion her received. e. f.
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
F only
![d. Write the sql command for Updating the contract column for all employees, who's job-
id is dir.man as " 1 year".
Write the sql command for Updating the contract column for all employees, who's job-
id is ceo as "4 years".
Mr William has been been promoted as an operational management with job-id of
"oper_man" with salary of (10000). Write the sql commands that will update mr William
record according to the promotion her received.
e.
f.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbf5d7124-10ec-44b1-ba44-99e95cc7d3aa%2F07df66c8-aef6-4b32-a3ad-b264c1b6f895%2F9bdghe_processed.jpeg&w=3840&q=75)
Transcribed Image Text:d. Write the sql command for Updating the contract column for all employees, who's job-
id is dir.man as " 1 year".
Write the sql command for Updating the contract column for all employees, who's job-
id is ceo as "4 years".
Mr William has been been promoted as an operational management with job-id of
"oper_man" with salary of (10000). Write the sql commands that will update mr William
record according to the promotion her received.
e.
f.
![S.no
Name
17 Hades
99 James
1001 Robert
500 John
400 Michael
11
David
45
William
Job.id
dept.man 23-Jul-15
dept.man
dir.man
ww
sales man
sales man
sales man
Hire-date Location
New York
sales man
7-Apr-13
31-Dec-
Los Angeles
17 Washington
25-Dec-
19 Austin
26-Jul-17 Dallas
25-Jan-19 Chicago
San
1-Jan-20 Francisco
Salary
160000
5000
7000
4000
4500
4000
3000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbf5d7124-10ec-44b1-ba44-99e95cc7d3aa%2F07df66c8-aef6-4b32-a3ad-b264c1b6f895%2Fjly5c3_processed.jpeg&w=3840&q=75)
Transcribed Image Text:S.no
Name
17 Hades
99 James
1001 Robert
500 John
400 Michael
11
David
45
William
Job.id
dept.man 23-Jul-15
dept.man
dir.man
ww
sales man
sales man
sales man
Hire-date Location
New York
sales man
7-Apr-13
31-Dec-
Los Angeles
17 Washington
25-Dec-
19 Austin
26-Jul-17 Dallas
25-Jan-19 Chicago
San
1-Jan-20 Francisco
Salary
160000
5000
7000
4000
4500
4000
3000
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY