Purpose: To demonstrate the ability to write basic SQL statements for creating database structures and constraints, processing single and multiple tables, and modifying and deleting data. Instructions: Using the Queen Anne Curiosity Shop (QACS) Project database on pages 263-269, write SQL statements for letters D P. Write and save the SQL statements using a text editor (e.g., Notepad). Although you only submit the SQL text file, you may want to test the SQL statements using MSSQL Server. The text file should contain the following SQL statements: 1. Use comment lines as descriptors for each different SQL statement. 2. Run the QACS Create Tables and the QACS Insert Values SQL scripts in order to create and populate the QACS database. This completes letters A C. 3. Write SQL for processing a single table. - Complete letter D. - Complete letter E. - Complete letter F. 4. Write SQL for processing multiple tables. - Complete letter G. - *Complete letter H. (See Note Below) - Complete letter I. - *Complete letter J. (See Note Below) - Complete letter K. - *Complete letter L. (See Note Below) - Complete letter M. - *Complete letter N. (See Note Below) - Complete letter O. - *Complete letter P. (See Note Below) - Complete letter Q. 5. Write SQL for modifying and deleting data. - Complete letter R. - Complete letter S. - Complete letter T *Note: Joins can be done using the JOIN ON syntax or the WHERE clause keyword; choose one method to complete the joins.