!!!!!!!!!!!!!!! Complete the practice exercise by drawing the three separate diagrams for HSD and create one document containing all three diagrams (a, b, and c). !!!!!!!!!!!!!!!!!!!

HEATHER SWEENEY DESIGNS 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 Chapter 3 Structured Query Language 245 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 Sweency 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. For reference, the SQL statements shown here are built from the HSD database design in Figure 5-26, the column specifications in Figure 5-25, and the referential integrity constraint specifications detailed in Figure 5-28. Figure 3-35 shows the tables in the Heather Sweeney Designs database as they appear in the Microsoft Access 2019 Relationships view. This figure illustrates the tables in the HSD database and the relationships between them. The Heather Sweeney Designs Database Tables in Microsoft Access 2019 The SQL statements to create the Heather Sweeney Designs (HSD) database are shown in Figure 3-36 in MySQL syntax. The SQL statements to populate the HSD database are shown in Figure 3-37, again in MySQL syntax. 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 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