{"id":209756,"date":"2018-09-14T11:24:37","date_gmt":"2018-09-14T11:24:37","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/14\/dbm-380-week-4-learning-team-mysql\/"},"modified":"2018-10-24T08:47:16","modified_gmt":"2018-10-24T08:47:16","slug":"dbm-380-week-4-learning-team-mysql","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/dbm-380-week-4-learning-team-mysql\/","title":{"rendered":"DBM 380 Week 4 Learning Team MySQL\u2122"},"content":{"rendered":"<p>DBM 380 Week 4 Learning Team: MySQL\u2122\tComplete work on your Learning Team Database.\tExecute the following queries in the Diamond Broker database:\t\uf0a7 Create an 1-page inventory list showing all the attributes for each diamond in inventory (both in stock and not in stock)\t\uf0a7 Show the total price and costs for all in stock inventory items\t\uf0a7 Show a 1-page list of all diamonds that are in stock and have a carat weight of over 1.0 carats\t\uf0a7 Show a 1-page list of customer names and order numbers for those customers that have placed an order in the past twelve months\t\uf0a7 Show a 1-page list of all orders with customer name and include all items that are on that order\tCompress the output of the queries including all of the scripts to create the database tables, to establish keys and constraints, to populate data within the database, and queries into a single ZIP folder.\tSubmit your ZIP folder to the Assignment Files tab.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBM 380 Week 4 Learning Team: MySQL\u2122 Complete work on your Learning Team Database. Execute the following queries in the Diamond Broker database: \uf0a7 Create an 1-page inventory list showing all the attributes for each diamond in inventory (both in <a href=\"https:\/\/www.benedictsol.com\/blogs\/dbm-380-week-4-learning-team-mysql\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-209756","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=209756"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209756\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=209756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=209756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=209756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}