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 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

Concept explainers

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

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

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