Complete the Heather Sweeney Designs Case Study at the end of the Chapter. Heather Sweeney is an interior designer who specializes in home kitchen design. She offers a variety of seminars at home. shows, kitchen and appliance stores, and other public locations. The seminars are free; she offers them as a way of building her customer base. She earns revenue by selling books and videos that instruct people on kitchen design. She also offers custom-design consulting services. After someone attends a seminar, Heather wants to leave no stone unturned in attempting to sell that person one of her products or services She would, therefore, like to develop a database to keep track of customers, the seminars they have attended, the contacts she has made with them, and the purchases they have made. She wants to use this database to continue to contact her customers and offer them products and services, including via a Web application that allows customers to create an account and purchase items online. We use the task of designing a database for Heather Sweeney Designs (HSD) as an example for our discussion of developing first the HSD data model in Chapter 4 (pages 295-303) and then the HSD database design in Chapter 5 (pages 371-378) Although you will study the HSD database development in detail in these chapters, you do not need to know that material to answer the following questions. Here we will take that final database design for Heather Sweeney Designs (HSD) and actually implement it in a database using the SQL techniques that you learned in this chapter. The complete case study can be found in your textbook. Please answer questions A-G Write SQL statements and answer questions for this database as follows A. Create a database named HSD in your DBMS. B. Write an SQL script based on Figure 3-36 to create the tables and relationships for the HSD database. Save this script, and then execute the script to create the HSD tables. C. Write an SQL script based on Figure 3-37 to insert the data for the HSD database. Save this script, and then execute the script to populate the HSD tables. NOTE: For your answers to parts D through O, you should create an SQI script to save and store your SQL statements. You can use one script to contain all the necessary statements. You can also include your answer to part P, but be sure to put it in comment marks so that it is interpreted as a comment by the DBMS and cannot actuallv be run! A. Create a database named HSD in your DBMS. B. Write an SQL script based on Figure 3-36 to create the tables and relationships for the HSD database. Save this script, and then execute the script to create the HSD tables. C. Write an SQL script based on Figure 3-37 to insert the data for the HSD database. Save this script, and then execute the script to populate the HSD tables. NOTE: For your answers to parts D through O, you should create an SQL script to save and store your SQL statements. You can use one script to contain all the necessary statements. You can also include your answer to part P, but be sure to put it in comment marks so that it is interpreted as a comment by the DBMS and cannot actually be run! D. Write SQL statements to list all columns for all tables. E. Write an SQL statement to list LastName, FirstName, and Phone for all customers who live in Dallas. F. Write an SQL statement to list LastName, FirstName, and Phone for all customers who live in Dallas and have a LastName that begins with th letter T. G. Write an SQL statement to list the InvoiceNumber for sales that include the Heather Sweeney Seminar Live in Dallas on 25OCT17 video. Use a subquery. woather Sweeney Designs Database Tables in Microsoft Access 2019 FIGURE 3.36 in th Create the HSD Database SQL Statements to Populate W CUSTOMER DATA '1440 Nest Palm Drive', 'Eort Worth', 'TX', '76110'; ; INSERT INTO CUSTOMER VALUES ( NuLt, 'Jacobs', 'chantel', 'Chantel. Jacobsegomewhere.co , NSERT INTO CUSTOMER VALUES NubL, 'Baker', 'Susan', 'Susan. Bakergelsewhere. com', NULL THO CUSTOMER VALUES INSERT INTO CUSTOMER VALUES INSERT INTO CUSTOMER VALUES NULL, 'Foxtrot', 'Kathy', 'Kathy. 'Oxeretedsomewhe INSERT INTO CUSTOMER VALUES ( NULL, 'George', 'Sally', 'Sal1y. Georgeqsomewhere. com', 'LK8G2typ', '972-233-634, '12034 San Jacinto', 'Dallas', 'TX', '75223'), INSERT INTO CUSTOMER. VALUES( INSERT INTO CUSTOMER VALUES INSERT INTO CUSTOMER VALUES NULL, 'Ranger', 'Terry', 'Terry. Rangeresomewhere. com', 'bv 3590F, ', '512-974-4455, '56 East 18 th Street', "Austin', 'TX', 78712); INSERT INTO CUSTOMER VALUES ! NULL, 'Tyler', 'Jenny', 'Jenny. Tyleresomewhere. com', 'Yu4be772', '972-233-6567.' "14056 South' Ervay Street', 'Dallas', 'TX', '75225', ; INSERT INTO CUSTOMER VALUES ( NULL, 'Wayne', 'Joan', 'Joan. Waynedelsewhere. com', 'JW4TX6g', '817-871-8245', '1660 South Aspen Drive', 'Fort Worth', 'TX', '76115')