1. Using the tables below, create a Salon ERD

2. Forward engineer the Salon database

3. Create an insert script to input the salon data found on I-Learn (Save file as SalonInsert.sql)

4.Do a Data Export of your Salon database (Save file as SalonDump.sql)

5. Do an Export As PNG on your ERD (Save file as SalonERD.png)

6. Write the queries listed below (Save file as SalonQueries.sql)

Query 1: Show the Name, Type and Price of items (products and services) purchased by each customer sorted by customer name

Query 2: Show the total spend of each customer sorted by spend descending

Query 3: Show the total revenue generated by each employee sorted by revenue descending

Query 4: Show each employee with their title, hire date, manager and manager title

• Submit the SalonQueries.sql file.

PD: I attached a screenshot of the salon DATA

Transcribed Image Text:

SalonData Location Table LocationID Address1 Address2 City State Zip 100 N Main St. Suite 3 Rexburg ID 83441 2 200 N Center St. NULL Rigby ID 83442 Customer Table LastName Bradford CustomerlD FirstName Email Phone jb@gmail.com |sh@gmail.com rt@gmail.com md@gmail.com hn@gmail.com ks@gmail.com jm@gmail.com 1 Jeana 1112223333 Sandra Hobbs Taylor Drake Nolan Smith Mendez 1112223334 3 Ryan 1112223335 4 Michelle 1112223336 5 Heidi 1112223337 6. Karen 1112223338 7 Jose 1112223339 SalonData Location Table LocationID Address1 Address2 City State Zip 100 N Main St. Suite 3 Rexburg ID 83441 2 200 N Center St. NULL Rigby ID 83442 Customer Table LastName Bradford CustomerlD FirstName Email Phone jb@gmail.com |sh@gmail.com rt@gmail.com md@gmail.com hn@gmail.com ks@gmail.com jm@gmail.com 1 Jeana 1112223333 Sandra Hobbs Taylor Drake Nolan Smith Mendez 1112223334 3 Ryan 1112223335 4 Michelle 1112223336 5 Heidi 1112223337 6. Karen 1112223338 7 Jose 1112223339

Answer rating: 100% (QA)

1ER diagram is attached 2 CREATE DATABASE Salon Data CREATE TABLE Location Location ID INT PRIMARY K... View the full answer