Learning Exercise

Database Search

This allows students to search databases on the internet, to find information that is being asked of them
Course: INFT 100
Share

Welcome to the second tutorial in our ongoing Introduction to SQL series! This week we'll take an in-depth look at using... see more

Exercise

DVD Databases Reviews of movies newly released on DVD are fairly easy to find, but critiques of other, older movies may be less accessible. To help film buffs, information on thousands of movie titles is available from a database on the World Wide Web. The Internet Movie Database Ltd. (www.imdb.com) can be searched using a movie’s title, cast members, year produced, characters, genre, awards, or other criteria. Each movie’s page offers a brief description and rating, and includes links to such items as stars, summary, trivia, reviews, quotes, goofs, and recommendations. Go to the Internet Movie Database Ltd, Web site and search the database for the questions below. Here is the Web site: www.imdb.com 1. In a list below, what are the top five at the Box Office? a. ______________________________ b. ______________________________ c. ______________________________ d. ______________________________ e. ______________________________ 2. What is the tenth Weekend Box-Office hit? __________________________ 3. Who is the director of the Tenth Box-Office hit? __________________________ 4. What is the tagline? ____________________________________________________________________________________________________________________________________________________________ 5. How much money did the first Box-Office hit make over the weekend? ____________________ 6. What type of genre is the first Box-Office hit? ________________________ 7. What is the tagline for the movie? ____________________________________________________________________________________________________________________________________________________________ 8. When was the movie released? _________________________________________ 9. Please list two of the writers: a. _____________________________________ b. _____________________________________ 10. Please list Five movies that are opening this week: a. __________________________________ b. __________________________________ c. __________________________________ d. __________________________________ e. __________________________________ 11. What is Today’s IMDb Poll Question? ____________________________________________________________________________________________________________________________________________________________ 12. What is out Today on DVD? 13. What is using the “Top 250 movies as voted by our users”: a. Ranked #1: ____________________________________ b. Ranked # 60: ___________________________________ i. How many votes did #60 receive? ________________ ii. What year did the movie come out in? _______________ 14. Using the 201st movie answer the questions below: a. What is the tagline? ________________________________________________________________________________________________________________________________________________ b. Who are the writers of the movie? i. ______________________________ ii. ______________________________ c. Who directed the movie? i. ______________________________ ii. ______________________________ d. What is the release date? ___________________________________ e. Did this movie win any awards? ________________________ f. If it did, what did they win:____________________________________________________________________________________________________________________________________________ g. What user rating did the movie receive? __________________________________ 15. Using the IMBd Bottom 100 fill out the following information: a. What was the number one ranked: ___________________________________________ b. How many votes did it receive? ______________________ c. When was it released? ______________________________ 16. What is the Movie/TV Quote of the Day? ____________________________________________________________________________________________________________________________________________________________ 17. Next thing to search would be Titles and type in “I Love Lucy.” Find the information below: a. Using Exact Match write down who the director is: _____________________________ b. Who are the writers: i. ____________________________ ii. ____________________________ c. What type of Genre is this classified under? ________________________ d. Where were the filming locations? __________________________________________ e. What movie connections does this have? ______________________________________________________________________ f. How long does this run? ___________________________________________ 18. Next, Search Quotes with the word “life” in the criteria for: a. What is the movie listed for # 12? ________________________________ b. What is the quote associated to #12? ________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ c. What year was this quote from? _________________ 19. Next, Search Keywords with the word “love” in the criteria for: a. The number one movie is called: _______________________ Released in: ___________ b. Love-letters shows up ranked as what number: __________________ c. What movie corresponds with love-letters?___________________________ d. How many titles are there? ___________________ e. Click on the Number 3 movie title and who is the director? _______________________________ f. What is the tagline to the movie? ________________________________________________________________________________________________________________________________________________ g. How many awards did this movie receive? ________________________________________________________________________ h. What is the release date? ____________________________________ i. What company released this movie? _______________________________________ j. What sound track corresponds to this movie? ___________________________________________________ k. Who are the starring roles of this movie? i. Actress: ________________________________________ ii. Actor: __________________________________________ 20. Go to www.blockbuster.com and answer the following questions: a. Using the Top 100 Movies list the movie titles for the specific number: i. #2: _____________________________________ ii. #12: ____________________________________ iii. #40:_____________________________________ iv. #64:_____________________________________ v. #72: _____________________________________ vi. #100:______________________________________ b. Using #64 answer the following questions: i. How many starts did it receive? ____________________ ii. Who does the movie star? ____________________________________________________________________________________________________________________________________________________________ iii. What is it rated? _____________________________ iv. What category does this fall under? ___________________________________ v. What is their price? ___________________________ c. Using #100 answer the following questions: i. How many starts did it receive? ____________________ ii. Who does the movie star? ____________________________________________________________________________________________________________________________________________________________ iii. What is it rated? _____________________________ iv. Who is the director? ______________________________ v. What category does this fall under? ___________________________________ vi. What is their subscriber price? ___________________________ d. Using #72 answer the following questions: i. How many starts did it receive? ____________________ ii. Who does the movie star? ____________________________________________________________________________________________________________________________________________________________ iii. What is it rated? _____________________________ iv. What category does this fall under? ___________________________________ v. What is their price? ___________________________ e. Using #40 answer the following questions: i. How many starts did it receive? ____________________ ii. Who does the movie star? ____________________________________________________________________________________________________________________________________________________________ iii. What is it rated? _____________________________ iv. What category does this fall under? ___________________________________ v. What is their subscriber price? ___________________________ f. Using #12 answer the following questions: i. How many starts did it receive? ____________________ ii. Who does the movie star? ____________________________________________________________________________________________________________________________________________________________ iii. What is it rated? _____________________________ iv. What category does this fall under? ___________________________________ v. What is their price? ___________________________ g. Using #2 answer the following questions: i. How many starts did it receive? ____________________ ii. Who does the movie star? ____________________________________________________________________________________________________________________________________________________________ iii. What is it rated? _____________________________ iv. What category does this fall under? ___________________________________ v. What is their price? ___________________________ vi. Who is the director? _____________________________________________________