1. It's raise time - everyone is getting a 5% raise. Write the statement to do this for all employees. 2. Gus Gray whose ID number is 22322, has earned an additional $500 on his bonus. Write the statement to make this change. 3. The employees who work in Arizona now have to take a payroll reduction of 2%. What would the statement look like to do this? 4. Write a query to insert a new record into the empinfo table (Hint: you are adding a full record - a new piece of information for each field/column) 5. Write a query to add a new record into the empinfo table - BUT, you only have the employee's first and last names along with their age at this point. Write a query for each question above. Sample Table: empinfo first last id age city state John Jones 99980 45 Payson Arizona Mary Jones 99982 25 Payson Arizona Eric Edwards 88232 32 San Diego California Mary Ann Edwards 88233 32 Phoenix Arizona Ginger Howell 98002 42 Cottonwood Arizona Sebastian Smith 92001 23 Gila Bend Arizona Gus Gray 22322 35 Bagdad Arizona Mary Ann May 32326 52 Tucson Arizona Erica Williams 32327 60 Show Low Arizona Leroy Brown 32380 22 Pinetop Arizona Elroy Cleaver 32382 22 Globe Arizona Sample Table: empsal id suprvsr salary bonus bonus amt office 99980 92001 45600 Y 3000 Arizona 99982 92001 47000 Y 3000 Arizona 88232 92001 52500 N California 88233 92001 49300 Y 3000 Arizona 98002 92001 52200 Y 3000 Arizona 92001 88888 65000 Y 5000 California 22322 32380 46800 Y 3000 Arizona 32326 32380 50900 N Arizona 32327 32380 48300 Y 3000 Arizona 32380 32380 53400 Y 3000 Arizona 32382 32380 55600 Y 3000 Arizona
1. It's raise time - everyone is getting a 5% raise. Write the statement to do this for all employees. 2. Gus Gray whose ID number is 22322, has earned an additional $500 on his bonus. Write the statement to make this change. 3. The employees who work in Arizona now have to take a payroll reduction of 2%. What would the statement look like to do this? 4. Write a query to insert a new record into the empinfo table (Hint: you are adding a full record - a new piece of information for each field/column) 5. Write a query to add a new record into the empinfo table - BUT, you only have the employee's first and last names along with their age at this point. Write a query for each question above. Sample Table: empinfo first last id age city state John Jones 99980 45 Payson Arizona Mary Jones 99982 25 Payson Arizona Eric Edwards 88232 32 San Diego California Mary Ann Edwards 88233 32 Phoenix Arizona Ginger Howell 98002 42 Cottonwood Arizona Sebastian Smith 92001 23 Gila Bend Arizona Gus Gray 22322 35 Bagdad Arizona Mary Ann May 32326 52 Tucson Arizona Erica Williams 32327 60 Show Low Arizona Leroy Brown 32380 22 Pinetop Arizona Elroy Cleaver 32382 22 Globe Arizona Sample Table: empsal id suprvsr salary bonus bonus amt office 99980 92001 45600 Y 3000 Arizona 99982 92001 47000 Y 3000 Arizona 88232 92001 52500 N California 88233 92001 49300 Y 3000 Arizona 98002 92001 52200 Y 3000 Arizona 92001 88888 65000 Y 5000 California 22322 32380 46800 Y 3000 Arizona 32326 32380 50900 N Arizona 32327 32380 48300 Y 3000 Arizona 32380 32380 53400 Y 3000 Arizona 32382 32380 55600 Y 3000 Arizona
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 20P
Related questions
Question
100%
| 1. It's raise time - everyone is getting a 5% raise. Write the statement to do this for all employees. |
| 2. Gus Gray whose ID number is 22322, has earned an additional $500 on his bonus. Write the statement to make this change. |
| 3. The employees who work in Arizona now have to take a payroll reduction of 2%. What would the statement look like to do this? |
| 4. Write a query to insert a new record into the empinfo table (Hint: you are adding a full record - a new piece of information for each field/column) |
| 5. Write a query to add a new record into the empinfo table - BUT, you only have the employee's first and last names along with their age at this point. |
|
Write a query for each question above.
|
| Sample Table: empinfo | |||||
| first | last | id | age | city | state |
| John | Jones | 99980 | 45 | Payson | Arizona |
| Mary | Jones | 99982 | 25 | Payson | Arizona |
| Eric | Edwards | 88232 | 32 | San Diego | California |
| Mary Ann | Edwards | 88233 | 32 | Phoenix | Arizona |
| Ginger | Howell | 98002 | 42 | Cottonwood | Arizona |
| Sebastian | Smith | 92001 | 23 | Gila Bend | Arizona |
| Gus | Gray | 22322 | 35 | Bagdad | Arizona |
| Mary Ann | May | 32326 | 52 | Tucson | Arizona |
| Erica | Williams | 32327 | 60 | Show Low | Arizona |
| Leroy | Brown | 32380 | 22 | Pinetop | Arizona |
| Elroy | Cleaver | 32382 | 22 | Globe | Arizona |
| Sample Table: empsal | |||||
| id | suprvsr | salary | bonus | bonus amt | office |
| 99980 | 92001 | 45600 | Y | 3000 | Arizona |
| 99982 | 92001 | 47000 | Y | 3000 | Arizona |
| 88232 | 92001 | 52500 | N | California | |
| 88233 | 92001 | 49300 | Y | 3000 | Arizona |
| 98002 | 92001 | 52200 | Y | 3000 | Arizona |
| 92001 | 88888 | 65000 | Y | 5000 | California |
| 22322 | 32380 | 46800 | Y | 3000 | Arizona |
| 32326 | 32380 | 50900 | N | Arizona | |
| 32327 | 32380 | 48300 | Y | 3000 | Arizona |
| 32380 | 32380 | 53400 | Y | 3000 | Arizona |
| 32382 | 32380 | 55600 | Y | 3000 | Arizona |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning