Heather Sweeney is an interior designer who specializes in home kitchen design. Her company is named Heather Sweeney Designs. Heather offers a variety of seminars at home shows, kitchen and appliance...

Heather Sweeney is an interior designer who specializes in home kitchen design. Her company is named Heather Sweeney Designs. Heather 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. The database will be named HSD. For reference, the SQL statements shown here are built from the HSD database design in Figure 7-49, the column characteristics specifications shown in Figure 7-50, and the referential integrity constraint specifications detailed in Figure 7-51.