Difference between revisions of "CSC220 Homework 5 2010"

From dftwiki3
Jump to: navigation, search
(Setup)
Line 20: Line 20:
  
 
* You can test the correctness of your test.sql program by testing it with the same php program I will use to grade the assignment.  More about this at the end of this page.
 
* You can test the correctness of your test.sql program by testing it with the same php program I will use to grade the assignment.  More about this at the end of this page.
 +
 +
=Dry Run=
 +
 +
* Login to your 220a-xx account on one of the Hadoop machines. 
 +
* Get a copy of the following php program which you will store in your public_html directory, and made readable by all: [[CSC220 testSql.php | testSql.php]]

Revision as of 16:18, 13 October 2010

--D. Thiebaut 20:04, 13 October 2010 (UTC)


Page under construction!
UnderConstruction.jpg

This assignment is due on 10/20/10, at 11:59 p.m. + 1 minute. You can work on it in pairs.


Setup

  • Your assignment is to write a collection of mysql queries that will be the answers to different questions.
  • In order to test these queries easily, you will need to include all of them in a text file (test.sql) that will become a single SQL program. This is the file you will submit for the assignment.
  • you will generate the different queries using phpmyadmin running on either hadoop101 or hadoop110.
  • You can test the correctness of your test.sql program by testing it with the same php program I will use to grade the assignment. More about this at the end of this page.

Dry Run

  • Login to your 220a-xx account on one of the Hadoop machines.
  • Get a copy of the following php program which you will store in your public_html directory, and made readable by all: testSql.php