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
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 stores SUM salary and the AVG salary per position. Submit your assignment.
Please explain steps by steps. I'm very new to this course, and have no Idea what to do!
Data Points:
Blanche Dishner 438927 Manager $25/h
372991 Night crew $17/h
Luciano Sloney 300126 Night crew $17/h
Dorris Goodsell Cashier $15/h
Sybil Fain 119325 Clerk $11/h
Shaun McNeil 200743 Cashier $13/h
Olen Wigley 222345 Cashier $14/h
Dovie Seawood 109321 Clerk $12/h
Magdalen Mullaney 256921 Cashier
Salena Souza 185549 Clerk $12/h
Paige Alvarez 132943 Clerk $11/h
Cassy Lundin 391285 Night crew
Tajuana Stoval 491621 Manager $23/h
Joaquina Piasecki 185392 Clerk $13/h
Janiece Abelson 244332 Cashier $13/h
Rogelio Peppler 128872 Clerk $11/h
Fatima Haymaker 100321 $13/h
Rico Fairbank 318821 Night crew $16/h
Trey Peloquin 488326 Manager $24/h
Paulene Thibeau 193931 Clerk $12/h
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started