2023 Assignment 7 Queries and Optimization Due Week 8 and worth 100 points Your supervisors and customers are very impressed with | Assignment Collections
Computer Science 2023 Computer Science Assignment – Queries and Optimization
2023 Assignment 7 Queries and Optimization Due Week 8 and worth 100 points Your supervisors and customers are very impressed with | Assignment Collections
Assignment 7: Queries and Optimization
Due Week 8 and worth 100 points 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.
· Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
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.
Click
Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using the following rubric.
|
Points: 100 |
Assignment 7: Queries and Optimization |
||||
|
Criteria |
Unacceptable Below 60% F |
Meets Minimum Expectations 60-69% D |
Fair 70-79% C |
Proficient 80-89% B |
Exemplary 90-100% A |
|
1. Describe a minimum of three (3) heuristics to optimize Queries. Weight: 15% |
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. Weight: 15% |
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. Weight: 20% |
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. Weight: 15% |
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. |
|
6. Three (3) References Weight: 5% |
No references provided |
Does not meet the required number of references; all references poor quality choices. |
Does not meet the required number of references; some references poor quality choices. |
Meets number of required references; all references high quality choices. |
Exceeds number of required references; all references high quality choices. |
|
7. Clarity, writing mechanics, and formatting requirements Weight: 10% |
More than 8 errors present |
7-8 errors present |
5-6 errors present |
3-4 errors present |
0-2 errors present |
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.
Place Order Now
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper
#Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational
