This assignment is for Database Management Systems class.

SQL Files : https://drive.google.com/drive/folders/1xgJP6BFQGf0BaFJM4HgV4FTeQluwGv1k?usp=sharing

Using the Entity Attribute Relationship (EAR) Diagram Provided Create and use a Database in MySQL and run the create.sql and populate.sql Note: when creating and Update or Delete script always run a select first to insure you're where statement is correct 1. Write a SQL Update to change customer 10011. New Name is'Technology Inc., New Address is '111 Franklin St, Philadelphia, PA 19130' 2. Write a SQL Delete to remove customer 10010 3. Write 3 SQL statements to find the highest (MAX), Lowest (MIN) and Average (AVG) price from the product table. 4. Rewrite 3 above to use 1 SQL statement with labels for each attribute the result should look like. Price Higlh Average 99.99 99.99 99.99 5. List vendor name, product name, product price and product description 6. List Customer name, order date, quantity, item price and product name. Sort the list by order date 7. List Vendor Name of Vendors that don't have products. 8. List Vendor Name, Product Name and Price. Sort the list by price descending. 9. List State and count of vendors by state (State, Count) use Group By (You will get NULL- 2 as one of the rows) Using the Entity Attribute Relationship (EAR) Diagram Provided Create and use a Database in MySQL and run the create.sql and populate.sql Note: when creating and Update or Delete script always run a select first to insure you're where statement is correct 1. Write a SQL Update to change customer 10011. New Name is'Technology Inc., New Address is '111 Franklin St, Philadelphia, PA 19130' 2. Write a SQL Delete to remove customer 10010 3. Write 3 SQL statements to find the highest (MAX), Lowest (MIN) and Average (AVG) price from the product table. 4. Rewrite 3 above to use 1 SQL statement with labels for each attribute the result should look like. Price Higlh Average 99.99 99.99 99.99 5. List vendor name, product name, product price and product description 6. List Customer name, order date, quantity, item price and product name. Sort the list by order date 7. List Vendor Name of Vendors that don't have products. 8. List Vendor Name, Product Name and Price. Sort the list by price descending. 9. List State and count of vendors by state (State, Count) use Group By (You will get NULL- 2 as one of the rows)