Deliverables: SQL Script with your name as follows: YourLastName_Project_Ph3.sql. MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc. ZIP file to include the two files mentioned above. Required Software: MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench. Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components. Lab Steps: Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. (From the attached screen shot) Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.   Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect.  Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql. Step 3: Include the following commands at the tops of your scripts: SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS STUDENT; DROP TABLE IF EXISTS CAMPUS; DROP TABLE IF EXISTS ROOM; DROP TABLE IF EXISTS COURSE; DROP TABLE IF EXISTS INSTRUCTOR; DROP TABLE IF EXISTS APPROVED_INSTRUCTOR; DROP TABLE IF EXISTS CLASS; DROP TABLE IF EXISTS STUDENT_GRADE; SET FOREIGN_KEY_CHECKS=1; Step 4: Create Tables in your database Create a new Table for each of the entities provided to you in the ERD diagram in Step 1. Add a column to represent each attribute addressed in the ERD diagram in Step 1. Designate Primary Key, as noted in the ERD diagram in Step 1. Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1. Enable referential integrity on the relationships, as needed. Enable cascade updates as needed on the relationships. Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables. Dates: they should have a date data designation type. Surrogate keys: shall be auto-numbered Character type: shall have a character data designation type. Step 6: Column Constraints Designation. Grade designation must be of one of these values as follows: A, B, C, D, E, F, W, E (E=enrolled, and W = withdrawn). Student's first and last names are not to be designated as NULL. Course Credit hours shall be BETWEEN one and four. The instructor first and last name must NOT be NULL Course name designation has to be UNIQUE and must not be NULL type. Step 7: Data Table Addition Use the INSERT operator to add minimum 3 rows of data per each database. You are free to use any values you might like for each of the columns. NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled. Step 8: Executing your SCRIPT Must incorporate the COMMIT command at the end of your Script Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created. Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script. EXECUTE your SCRIPT. Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

The purpose of this assignment is to create a data story and communicate findings to key stakeholders.Part 1: For this assignment, you will use the "Arizona Incomes by Zip Code" dataset. You will use Tableau to create a data story that illustrates the median household incomes of Arizona residents. The data provided includes all zip codes in Arizona. Each record is a unique zip code. The data includes the following columns:Zip_Code: An Arizona zip code.Metro_Area: Whether or not the zip code is within the Phoenix-metro area.City: The city name of the zip code.Median_Income: The median household income of each zip code based on 5-year estimates (2010-2014) from the U.S. Census Bureau.The marketing manager has asked you to analyze income data for Arizona residents so that leaders in his department can determine the company's advertising strategy. The marketing manager intends to share this data with other decisions makers and the marketing department staff so that everyone has a thorough understanding of how the income information can be used to determine specific target markets in upcoming advertising campaigns. Because most of these individuals do not have a strong understanding of analytics, they must be able gain the information listed below from studying the charts. In the data story, use visualizations, heat maps, boxplots, etc. to describe the following:How do incomes differ across zip codes within the Phoenix-metro area (using geo-mapping)?What is the relative difference in incomes across zip codes within the Phoenix-metro area (use a heat map)?What are the distribution of incomes across Arizona?How do incomes within the Phoenix metro area differ from those outside of that area?Part 2: Demonstrate the ability to communicate the analytics story to key stakeholders, including the marketing manager, by creating a 6-10 slide PowerPoint presentation (with speaker notes for each slide). Use the charts generated in Tableau to illustrate the data story as it relates to the income of Arizona residents. The slides and speaker notes should address the following for each chart presented.What information is the chart providing to stakeholders?Why is the information in the chart important to key stakeholders?How can this information be used in making decisions about how marketing dollars can be allocated?Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.While APA format is not required for the body of this assignment solid academic writing is expected, and documentation of sources should be presented using APA formatting, guidelines, which can be found in the APA Style Guide, located in the Student Success Center.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.