{"id":11161,"date":"2021-10-25T11:23:59","date_gmt":"2021-10-25T11:23:59","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/sql-homework-select-and-update-data-in-related-tables-dbm380-database-concepts-university-of-phoenix\/"},"modified":"2021-10-25T11:23:59","modified_gmt":"2021-10-25T11:23:59","slug":"sql-homework-select-and-update-data-in-related-tables-dbm380-database-concepts-university-of-phoenix","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/sql-homework-select-and-update-data-in-related-tables-dbm380-database-concepts-university-of-phoenix\/","title":{"rendered":"Sql homework select and update data in related tables | DBM380 Database Concepts | University of Phoenix"},"content":{"rendered":"<div>\n<p>\u00a0<\/p>\n<p>Running reports on existing data and updating data records are very common tasks in the industry.<\/p>\n<p>For this assignment, you will begin with a database containing several pre-populated tables.<\/p>\n<p><strong>Download<\/strong> and <strong>unzip<\/strong> the Microsoft\u00ae Access\u00ae database (ZIP file) available on the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/www.cengage.com\/cgi-wadsworth\/course_products_wp.pl?fid=M63&amp;product_isbn_issn=9781305627482&amp;chapter_number=0&amp;resource_id=277&amp;altname=Student%20Data%20Files\">Cengage&#8217;s website<\/a>. (You may need to convert the database depending on the version of Microsoft\u00ae Access\u00ae you are using. To convert the database, follow Microsoft\u00ae&#8217;s <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.office.com\/en-us\/article\/convert-a-database-to-the-accdb-file-format-098ddd31-5f84-4e89-8f44-db0cf7c11acd\">Convert a Database to the .accdb File Format<\/a>instructions.)<\/p>\n<p><strong>Open<\/strong> the database in Microsoft\u00ae Access\u00ae and explore the tables it contains by following this path:<\/p>\n<p><em>\/folderYouNameWhenYouUnzip\/1305627482_526407\/Student\/Ch07-Intro-to-SQL\/Databases\/<\/em><em><strong>Ch07_SaleCo.mdb<\/strong><\/em><\/p>\n<p><em>Note<\/em>: If you have chosen not to use Microsoft\u00ae Access\u00ae in this course, you will need to download the SQL statements for MySQL, Oracle\u00ae, or SQLserver and run those statements against your RDBMS to create a populated database.<\/p>\n<p><strong>Download<\/strong> the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/myresource.phoenix.edu\/secure\/resource\/DBM380r14\/DBM380r14_Wk4_Select_Update_Data_Related_Tables.docx\">Select and Update Data in Related Tables<\/a> document and follow the instructions.<\/p>\n<p>Your completed assignment will consist of one document and two screenshots placed in one document (<u><em><strong>one screenshot showing the results of the &#8220;before&#8221; SELECT statement and a second showing the results of the &#8220;after&#8221; SELECT statement).<\/strong><\/em><\/u><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Running reports on existing data and updating data records are very common tasks in the industry. For this assignment, you will begin with a database containing several pre-populated tables. Download and unzip the Microsoft\u00ae Access\u00ae database (ZIP file) available on the Cengage&#8217;s website. (You may need to convert the database depending on the version [&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-11161","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/11161","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=11161"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/11161\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=11161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=11161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=11161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}