Reference no: EM13312128

Your supervisors and customers are very impressed with the database you have put together. However, there is still that questioning executive that wants validation the database is useful; after all, he is saying that we have put a lot of data in, but does not see information out. To this end, you will be designing reports / queries that will be of use to the restaurant executives and other managers of the company.

Write a 2-3 page paper in which you:

1. Describe a minimum of three (3) heuristics to optimize Queries.
2. Provide the SQL code (and screen shots) based on the following criteria:
   • You must deliver five (5) queries in total for this assignment.
   • One of your five queries must select from three (3) different tables.
   • Four of your queries must select from two (2) tables.
   • Include comments on how you are using the optimization rules you described and discussed earlier.
   • Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.