{"id":56011,"date":"2022-04-25T14:38:32","date_gmt":"2022-04-25T14:38:32","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/erd-diagram-project-using-mysql\/"},"modified":"2022-04-25T14:38:32","modified_gmt":"2022-04-25T14:38:32","slug":"erd-diagram-project-using-mysql","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/erd-diagram-project-using-mysql\/","title":{"rendered":"Erd diagram, project, using mysql"},"content":{"rendered":"<div>\n<p>\u00a0\u00a0<\/p>\n<p>Build out the ERD diagrams for the entire solution based on the following questions (you must have at least 3 tables for full credit, there is no limit based on your simplification of the data. The simplification of the data should follow the in-class examples of data, with no duplication in tables)<\/p>\n<p>Provide\u00a0<\/p>\n<p>I. The MYSQL code (within the word document) to build the database and tables<\/p>\n<p>II. The MYSQL code (within the word document) to answer each of the following questions<\/p>\n<p>III. Provide screen shots answering each question along with any supporting text<\/p>\n<p><em>The answers must be done in SQL, not table presentation and manual interpretation of the data<\/em><\/p>\n<p>Questions :<\/p>\n<p>1. What is the total revenue for the year?\u00a0<\/p>\n<p>2. What is the gross profit for the year? (based only on what is in the tables)<\/p>\n<p>3. How much revenue did each wine provide for the year?<\/p>\n<p>4. What is the Average revenue per month per location for the year?<\/p>\n<p>5. What is the final inventory of the Premium Red wine?<\/p>\n<p>6. If the retail price of the wine increases by 10%, what is the gross profit margin ?<\/p>\n<p>7. How many bottles of the different wines were ordered in July?\u00a0<\/p>\n<p>8. What is the revenue per year per restaurant?<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0\u00a0 Build out the ERD diagrams for the entire solution based on the following questions (you must have at least 3 tables for full credit, there is no limit based on your simplification of the data. The simplification of the data should follow the in-class examples of data, with no duplication in tables) Provide\u00a0 I. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-56011","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/56011","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=56011"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/56011\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=56011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=56011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=56011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}