Imagine you work for an independent grocery store with 20 employees. The business owner has tasked you with creating a relational database that will track employee names, IDs, positions (e.g., cashier, manager, clerk, or night crew), and salaries.Create a relational database table in Microsoft® Excel® for the grocery store using the provided data points.Apply the universal rules (unique primary keys, unique column names, no duplicate rows) to your table.Include all necessary null values.Display in the table the requested database queries:INSERT INTO Account: VALUES (188820, ‘Wendall Glass’, $12/h)UPDATE Account: Set salary = $12/h WHERE ID = 128872DELETE FROM Account WHERE ID = 244332Calculate the grocery store’s SUM salary and the AVG salary per position. Sheet1+ACEF1 IDNAMEEMP IDPOSITIONRATE1 Blanche Dishner438927Manager$25.0032 NULL372991Night crew$17.0043 Luciano Sloney300126Night crew$17.0054 Dorris GoodsellNULLCashier$15.005 Sybil Fain6 Shaun McNeil7 Olen Wigley119325Clerk$11.007200743Cashier$13.008222345Cashier$14.0098 Dovie Seawood109321Clerk$12.009 Magdalen Mullaney256921Cashier$-101110 Salena Souza185549Clerk$12.001211 Paige Alvarez132943Clerk$11.001312 Cassy Lundin391285Night crew$-1413 Tajuana Stoval491621Manager$23.001514 Joaquina Piasecki185392Clerk$13.001615 Janiece Abelson244332Cashier$13.0016 Rogelio Peppler17 Fatima Haymaker17128872Clerk$11.0018100321NULL$13.001918 Rico Fairbank318821Night crew$16.002019 Trey Peloquin488326Manager$24.002120 Paulene Thibeau193931Clerk$12.0022

INSERT INTO Account: VALUES (188820, ‘Wendall Glass’, $12) UPDATE Account: Set salary = $12 WHERE ID…

Answered: Imagine you work for an independent…

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

Question

Imagine you work for an independent grocery store with 20 employees. The business owner has tasked you with creating a relational database that will track employee names, IDs, positions (e.g., cashier, manager, clerk, or night crew), and salaries. Create a relational database table in Microsoft® Excel® for the grocery store using the provided data points. Apply the universal rules (unique primary keys, unique column names, no duplicate rows) to your table. Include all necessary null values. Display in the table the requested database queries: INSERT INTO Account: VALUES (188820, ‘Wendall Glass’, $12/h) UPDATE Account: Set salary = $12/h WHERE ID = 128872 DELETE FROM Account WHERE ID = 244332 Calculate the grocery store’s SUM salary and the AVG salary per position.

Sheet1
+
A
C
E
F
1 ID
NAME
EMP ID
POSITION
RATE
1 Blanche Dishner
438927
Manager
$25.00
3
2 NULL
372991
Night crew
$17.00
4
3 Luciano Sloney
300126
Night crew
$17.00
5
4 Dorris Goodsell
NULL
Cashier
$15.00
5 Sybil Fain
6 Shaun McNeil
7 Olen Wigley
119325
Clerk
$11.00
7
200743
Cashier
$13.00
8
222345
Cashier
$14.00
9
8 Dovie Seawood
109321
Clerk
$12.00
9 Magdalen Mullaney
256921
Cashier
$-
10
11
10 Salena Souza
185549
Clerk
$12.00
12
11 Paige Alvarez
132943
Clerk
$11.00
13
12 Cassy Lundin
391285
Night crew
$-
14
13 Tajuana Stoval
491621
Manager
$23.00
15
14 Joaquina Piasecki
185392
Clerk
$13.00
16
15 Janiece Abelson
244332
Cashier
$13.00
16 Rogelio Peppler
17 Fatima Haymaker
17
128872
Clerk
$11.00
18
100321
NULL
$13.00
19
18 Rico Fairbank
318821
Night crew
$16.00
20
19 Trey Peloquin
488326
Manager
$24.00
21
20 Paulene Thibeau
193931
Clerk
$12.00
22

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 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