Database schemas:
Structured Query Language 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 Curiousity Shop Project database on pages 236-242, write SQL statements for letters D -V. 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 by implementing them using MSSQL Server. The text file should contain the following SQL statements Use comment lines as descriptors for each different SQL statement. Run the QACS Create Tables and the QACS Insert Data SQL scripts in order to create and populate the QACS database. This completes letters A - C Write SQL for processing a single table Complete letter D Complete letter E. o o Write SQL for processing multiple tables. o Complete letter F o Complete letter G o *Complete letter H. o Complete letter I o *Complete letterJ o Complete letter K. o *Complete letter L o Complete letter M. o *Complete letter N o Complete letter O o Complete letter P o Complete letter Q o *Complete letter R. Write SQL for modifying and deleting data. o Complete letter S o Complete letter 1T o Complete letter U o Complete letter V *Note: Joins can be done using the JOIN ON syntax or the WHERE keyword; choose one method to complete the joins. Structured Query Language 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 Curiousity Shop Project database on pages 236-242, write SQL statements for letters D -V. 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 by implementing them using MSSQL Server. The text file should contain the following SQL statements Use comment lines as descriptors for each different SQL statement. Run the QACS Create Tables and the QACS Insert Data SQL scripts in order to create and populate the QACS database. This completes letters A - C Write SQL for processing a single table Complete letter D Complete letter E. o o Write SQL for processing multiple tables. o Complete letter F o Complete letter G o *Complete letter H. o Complete letter I o *Complete letterJ o Complete letter K. o *Complete letter L o Complete letter M. o *Complete letter N o Complete letter O o Complete letter P o Complete letter Q o *Complete letter R. Write SQL for modifying and deleting data. o Complete letter S o Complete letter 1T o Complete letter U o Complete letter V *Note: Joins can be done using the JOIN ON syntax or the WHERE keyword; choose one method to complete the joins
