Professional Writers
We assemble our team by selectively choosing highly skilled writers, each boasting specialized knowledge in specific subject areas and a robust background in academic writing
Order For Similar Custom Papers & Assignment Help Services
Fill the order form details - writing instructions guides, and get your paper done.
Posted:
Database help | DAT210 Data Programming Languages | University of Phoenix
Assignment Content
- 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.
Get custom essay samples and course-specific study resources via course hero homework for you service – 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.
Data Points
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
Why choose us
You Want Quality and That’s What We Deliver
Discounted Prices
Our service is committed to delivering the finest writers at the most competitive rates, ensuring that affordability is balanced with uncompromising quality. Our pricing strategy is designed to be both fair and reasonable, standing out favorably against other writing services in the market.
AI & Plagiarism-Free
Rest assured, you'll never receive a product tainted by plagiarism or AI-generated content. Each paper is research-written by human writers, followed by a rigorous scanning process of the final draft before it's delivered to you, ensuring the content is entirely original and maintaining our unwavering commitment to providing plagiarism-free work.
How it works
When you decide to place an order with Nurscola, here is what happens: