Assignment: ERD Diagram, Project, Using MySQL
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
• The MYSQL code (within the word document) to build the database and tables
• The MYSQL code (within the word document) to answer each of the following questions
• Provide screen shots answering each question along with any supporting text
The answers must be done in SQL, not table presentation and manual interpretation of the data
Task:
• What is the total revenue for the year?
• What is the gross profit for the year? (based only on what is in the tables)
• How much revenue did each wine provide for the year?
• What is the Average revenue per month per location for the year?
• What is the final inventory of the Premium Red wine?
• If the retail price of the wine increases by 10%, what is the gross profit margin ?
• How many bottles of the different wines were ordered in July?
• What is the revenue per year per restaurant?
Format your assignment according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the assignment, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.