Describe a minimum of three 3 heuristics to optimize

Reference no: EM13463999

Your supervisors and customers are very impressed with the database you have put together. However, there is still that questioning executive who 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. (Yes this is on restaurant as we have been doing since assignment 2)

Write a two to three (2-3) page paper in which you:

1. Describe a minimum of three (3) heuristics to optimize queries. (research what heuristics or rule basedis and how related to optimization of queries and discuss 3) this is the only portion of this assignment where you would have resources/references for

2. Provide the SQL code (and screen shots) based on the following criteria:

a. You must deliver five (5) queries in total for this assignment.

b. One (1) of your five (5) queries must select from three (3) different tables. (Do not let the word heuristics and if you do not fully understand from doing this portion, focus on 1 useful query thathas fields from 3 of your tables and do a screenshot of both the code that created it and theresult which is hopefully successful) So if you have not created 3 tables in the database we have been creating then you have more work to do before you can do the queries....

remember there is partial credit soif you cannot query from 3 tables then give me any query so I can give you something...

c. Four (4) of your queries must select from two (2) tables. (Make 4 queries that have fields from 2 tables and provide screenshot that shows both the creation of the queries and results)

d. Include comments on how you are using the optimization rules you described and discussed earlier. (If you did not use then at least discuss how you might use them)

3. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Reference no: EM13463999

Questions Cloud

Describe some of the tools and techniques that you can use : describe some of the tools and techniques that you can use as a project manager to mitigate risk in your projects.

When would be the appropriate time to begin the forensic : read the case study on page 381-382 and then answer the following questions what can be done to minimize the risk of

What is web 20 how do organizations use web 20 your : what is web 2.0? how do organizations use web 2.0? your response should be at least 200 words in length. you are

The system to be developed will allow a large company to : you have been asked to be the project manager for the development of an information technology it project. the system

Describe a minimum of three 3 heuristics to optimize : your supervisors and customers are very impressed with the database you have put together. however there is still that

The technology required for themwrite a paper explaining : write a paper explaining the business uses of cloud computing and web 2.0. your paper should be 3 pages in length and

Determine the purpose of the css float style not described : 1.what is the purpose of the css float style? not explained well in class will post a brief handout with a better

Use as an example the threats to the information security : part 1 review questions why do networking components need more examination from an information security perspective

Choose two 2 tech stock companies that attempted to make : 1. select two 2 tech stock companies that attempted to make profits from rising consumer demand after the crash.

User Account

All Pages