IT 264 Week 4
Resources: Appendix B
Your database created in Retail Scenario, Part 1
/* NOTE: If any corrections to the table structures submitted for Part 1 were required you must provide the CREATE TABLE commands for the corrected/updated tables. */
Use the INSERT command to add at least 20 rows of data into each table created in Week Two. Insert data appropriate for the data type of each field. Because your primary key field was set up as an identify seed, you do not need to add data to that field. Consider the relationships the tables have to one another to ensure foreign keys are added correctly.
Develop two SELECT commands for each table. One of the commands for each table should use a WHERE clause to filter the records being returned.
Execute each of your SELECT commands to ensure they are working correctly. In the Results window select all results for each SELECT command, copy with headers, and paste to the Output Results section of Appendix B, labeled to indicate which SELECT command they are from. (Screen shots of results will not meet this requirement.)
Save all your SQL code to your workspace for later use and provide a summary of the save process in the Solution Summary section of Appendix B.
Complete Appendix B, including all SQL code for your INSERT and SELECT commands and all results for the SELECT commands in the appropriate sections.
