Lab 2

Due September 20

Goal

To gain experience using phpmyadmin to create useful queries

Activity

Do the following queried using phpmyadmin on page 69, "Henry Books Case"

1,2,5,7,9, 12, 13, 15

1. List the name of each publisher that’s not located in New York.
2. List the title of each book published by Penguin USA.
5. List the title of each book that has the type PSY or whose publisher code is JP.
7. How many books have a publisher code of ST or VB?
9. List the title of each book that has the type FIC and that was written by John Steinbeck.
12. List the branch number, copy number, quality, and price for each copy of The Stranger.
13. List the branch name, copy number, quality, and price for each copy of Electric Light.
15. For each book copy available at the Henry on the Hill branch whose quality is excellent, list the book’s title and author names (in the order listed on the cover).

Solutions

For each, build a query and run. Check the answer to make sure it is right.

Make a Word file with the following:

  1. For each query, turn in the SQL that was generated
  2. The query results. The results can be included as a screen shot, or you may export to CSV and copy into you document.
Turn in the complete results on Moodle
Topic revision: r2 - 2013-10-21 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback