Blog

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. a relational database table in Microsoft® Excel® for the grocery store using the provided . the universal rules (unique primary keys, unique column names, no duplicate rows) to your table. all necessary null values. in the table the requested database queries: the grocery store’s SUM salary and the AVG salary per position. 1. Blanche Dishner – 438927 – Manager – $25/h 2. 372991 – Night crew – $17/h 3. Luciano Sloney – 300126 – Night crew – $17/h 4. Dorris Goodsell – Cashier – $15/h 5. Sybil Fain – 119325 – Clerk – $11/h 6. Shaun McNeil – 200743 – Cashier – $13/h 7. Olen Wigley – 222345 – Cashier – $14/h 8. Dovie Seawood – 109321 – Clerk – $12/h 9. Magdalen Mullaney – 256921 – Cashier 10. Salena Souza – 185549 – Clerk – $12/h 11. Paige Alvarez – 132943 – Clerk – $11/h 12. Cassy Lundin – 391285 – Night crew 13. Tajuana Stoval – 491621 – Manager – $23/h 14. Joaquina Piasecki – 185392 – Clerk – $13/h 15. Janiece Abelson – 244332 – Cashier – $13/h 16. Rogelio Peppler – 128872 – Clerk – $11/h 17. Fatima Haymaker – 100321 – $13/h 18. Rico Fairbank – 318821 – Night crew – $16/h 19. Trey Peloquin – 488326 – Manager – $24/h 20. Paulene Thibeau – 193931 – Clerk – $12/h Purchase the answer to view it