DAT 210 Anthem College Phoenix Data Programming Languages Project

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.