Queries and Optimization

The specific course learning outcomes associated with this assignment are:
Explain how data is physically stored and accessed.
Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Use technology and information resources to research issues in database systems.
Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

1. Describe a minimum of three (3) heuristics to optimize Queries.

Did not submit or incompletely described a minimum of three (3) heuristics to optimize Queries.
Insufficiently described a minimum of three (3) heuristics to optimize Queries.
Partially described a minimum of three (3) heuristics to optimize Queries.
Satisfactorily described a minimum of three (3) heuristics to optimize Queries.
Thoroughly described a minimum of three (3) heuristics to optimize Queries.
2. Provide the SQL code (and screen shots) that delivers five (5) queries in total for this assignment.

Did not submit or incompletely provided the SQL code (and screen shots) that delivered five (5) queries in total for this assignment.
Insufficiently provided the SQL code (and screen shots) that delivered five (5) queries in total for this assignment.
Partially provided the SQL code (and screen shots) that delivered five (5) queries in total for this assignment.
Satisfactorily provided the SQL code (and screen shots) that delivered five (5) queries in total for this assignment.
Thoroughly provided the SQL code (and screen shots) that delivered five (5) queries in total for this assignment.
3. Provide the SQL code (and screen shots) where one of your five queries must select from three (3) different tables.

Did not submit or incompletely provided the SQL code (and screen shots) where one of your five queries selected from three (3) different tables.
Insufficiently provided the SQL code (and screen shots) where one of your five queries selected from three (3) different tables.
Partially provided the SQL code (and screen shots) where one of your five queries selected from three (3) different tables.
Satisfactorily provided the SQL code (and screen shots) where one of your five queries selected from three (3) different tables.
Thoroughly provided the SQL code (and screen shots) where one of your five queries selected from three (3) different tables.
4. Provide the SQL code (and screen shots) where four of your queries must select from two (2) tables.

Did not submit or incompletely provided the SQL code (and screen shots) where four of your queries selected from two (2) tables.
Insufficiently provided the SQL code (and screen shots) where four of your queries selected from two (2) tables.
Partially provided the SQL code (and screen shots) where four of your queries selected from two (2) tables.
Satisfactorily provided the SQL code (and screen shots) where four of your queries selected from two (2) tables.
Thoroughly provided the SQL code (and screen shots) where four of your queries selected from two (2) tables.
5. Provide the SQL code (and screen shots) that includes comments on how you are using the optimization rules you described and discussed earlier.

Did not submit or incompletely provided the SQL code (and screen shots) that included comments on how you are using the optimization rules you described and discussed earlier.
Insufficiently provided the SQL code (and screen shots) that included comments on how you are using the optimization rules you described and discussed earlier.
Partially provided the SQL code (and screen shots) that included comments on how you are using the optimization rules you described and discussed earlier.
Satisfactorily provided the SQL code (and screen shots) that included comments on how you are using the optimization rules you described and discussed earlier.
Thoroughly provided the SQL code (and screen shots) that included comments on how you are using the optimization rules you described and discussed earlier.