Yorkville High School Computer Science Department
Yorkville High School Computer Science Department on Facebook  Yorkville High School Computer Science Department Twitter Feed  Yorkville High School Computer Science Department on Instagram

Yorkville High School Computer Science

ASSIGNMENTS: Web App Attribute List - October 22, 2018 :: UI Project Paper Prototype - October 23, 2018 :: Challenges 5 - November 2, 2018 >>

Database Programming :: Projects :: Optimized Video

Rubric
Lesson
Due: Sep 28

Problem

For each of the following queries, use EXPLAIN to see how the query will be executed. Then add index(es), and retry the EXPLAIN to see how the query has been improved (or not). Write about what you tried and why in a Google Doc. Try at least two indexes for each query. You should include the explain table for each query you attempt.

List the MovieCode, Title, and Price for every movie between $20 and $30 (inclusive).

For each type of movie, list the type and average price in ascending order of price.

Find the Title and Studio Name for every movie directed by Steven Spielberg.

List all the movie titles in descending order at the downtown Naperville branch.

List the directors with movies produced by Warner Brothers. Each director should be listed exactly once and they should be listed in alphabetical order.

Finally, list all of your query results in order from fastest to slowest in the Google Doc.

Yorkville High School Computer Science Department on Facebook Yorkville High School Computer Science Department Twitter Feed Yorkville High School Computer Science Department on Instagram