(Solved): a. Break up the dependency diagram shown to create new dependency diagrams such that the resulting ...

a. Break up the dependency diagram shown to create new dependency diagrams such that the resulting dependency diagrams are in \( 2 \mathrm{NF} \). (15 points) -he resulting diagrams to produce a set of dependency diagrams that are all (0 points) oin types are included in the outer join classification? (5 points) 4. Given the following SQL query: SELECT * FROM VENDORS WHERE V_STATE IN ('TN', 'FL', GA'); The WHERE clause is used to identify vendors in either of Tennessee, Florida, or Georgia. Rewrite the WHERE clause of this query without using the IN operator. (10 points) Use the following data model to write the SQL queries for questions 5-9. 5. List the customer number, the name (first and last), and the balance of the customers. (10 points) 5. List the customer number, the name (first and last), and the balance of the customers. (10 points) 6. List the customer number, the name (first and last), and the balance of customers who reside in Colorado (Custstate is \( \mathrm{CO}) \). (10 points) 7. List all columns of the PRODUCT table for all products costing more than \( \$ 50 \). Sort the results by product manufacturer, then by product name, both in ascending order. (10 points) 8. List the product number, name, and price of products ordered by customer number C0954327 in January 2021. Remove duplicate products in the result. (10 points) 9. List the average balance of customers by city. Include only those customers residing in Florida (Custstate is \( \mathrm{FL}) \). (10 points) 10. Explain the difference between an ORDER BY clause and a GROUP BY clause. (10 points) 11. Complete Module 7 Use it 12. Complete Module 7 Activities 1 \& 2. EXTRA CREDIT ASSIGNMENT 1. Complete Module 8 Activity 1. Please note that all Practice Activities for Modules 7 and 8 have been opened to help with preparation for completing this assignment as well as to provide general practice with writing SQL queries.