{"id":7597,"date":"2021-10-13T16:34:23","date_gmt":"2021-10-13T16:34:23","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/database-help-dat210-data-programming-languages-university-of-phoenix\/"},"modified":"2021-10-13T16:34:23","modified_gmt":"2021-10-13T16:34:23","slug":"database-help-dat210-data-programming-languages-university-of-phoenix","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/database-help-dat210-data-programming-languages-university-of-phoenix\/","title":{"rendered":"Database help | DAT210 Data Programming Languages | University of Phoenix"},"content":{"rendered":"<div>\n<p>\u00a0<\/p>\n<h2>Assignment Content<\/h2>\n<ol>\n<li><strong>Imagine <\/strong>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.\n<p><strong>Create<\/strong> a relational database table in Microsoft\u00ae Excel\u00ae for the grocery store using the provided <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/myresource.phoenix.edu\/secure\/resource\/DAT210v3\/DAT210_v3_wk1_data_points.docx\"><u>data points<\/u><\/a>.<\/p>\n<p><strong>Apply<\/strong> the universal rules (unique primary keys, unique column names, no duplicate rows) to your table.<\/p>\n<p><strong>Include<\/strong> all necessary null values.<\/p>\n<p><strong>Display <\/strong>in the table the requested database queries:<\/p>\n<ul>\n<li>INSERT INTO Account: VALUES (188820, \u2018Wendall Glass\u2019, $12\/h)<\/li>\n<li>UPDATE Account: Set salary = $12\/h WHERE ID = 128872<\/li>\n<li>DELETE FROM Account WHERE ID = 244332<\/li>\n<li><strong>Calculate<\/strong> the grocery store\u2019s SUM salary and the AVG salary per position.\u00a0\n<p>\u00a0<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Data Points<\/p>\n<p>1. Blanche Dishner \u2013 438927 &#8211; Manager &#8211; $25\/h\u00a0<\/p>\n<p>2. 372991 \u2013 Night crew &#8211; $17\/h<\/p>\n<p>3. Luciano Sloney \u2013 300126 \u2013 Night crew &#8211; $17\/h<\/p>\n<p>4. Dorris Goodsell \u2013 Cashier &#8211; $15\/h<\/p>\n<p>5. Sybil Fain \u2013 119325 \u2013 Clerk &#8211; $11\/h<\/p>\n<p>6. Shaun McNeil \u2013 200743 \u2013 Cashier &#8211; $13\/h<\/p>\n<p>7. Olen Wigley \u2013 222345 \u2013 Cashier &#8211; $14\/h<\/p>\n<p>8. Dovie Seawood \u2013 109321 \u2013 Clerk &#8211; $12\/h<\/p>\n<p>9. Magdalen Mullaney \u2013 256921 \u2013 Cashier<\/p>\n<p>10. Salena Souza \u2013 185549 \u2013 Clerk &#8211; $12\/h<\/p>\n<p>11. Paige Alvarez &#8211; 132943 \u2013 Clerk &#8211; $11\/h<\/p>\n<p>12. Cassy Lundin \u2013 391285 \u2013 Night crew<\/p>\n<p>13. Tajuana Stoval &#8211; 491621 \u2013 Manager \u2013 $23\/h<\/p>\n<p>14. Joaquina Piasecki \u2013 185392 \u2013 Clerk &#8211; $13\/h<\/p>\n<p>15. Janiece Abelson \u2013 244332 \u2013 Cashier &#8211; $13\/h<\/p>\n<p>16. Rogelio Peppler \u2013 128872 \u2013 Clerk &#8211; $11\/h<\/p>\n<p>17. Fatima Haymaker \u2013 100321 &#8211; $13\/h<\/p>\n<p>18. Rico Fairbank \u2013 318821 \u2013 Night crew &#8211; $16\/h<\/p>\n<p>19. Trey Peloquin \u2013 488326 \u2013 Manager &#8211; $24\/h\u00a0<\/p>\n<p>20. Paulene Thibeau \u2013 193931 \u2013 Clerk &#8211; $12\/h\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 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\u00ae Excel\u00ae for the grocery store using the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-7597","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/7597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=7597"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/7597\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=7597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=7597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=7597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}