SQL Assignment

Due: November 6, 2009

  1. Download the file CRSP Data File Pt 1. How many records are in the file?
  2. Create a table to hold all of the information in the file.
  3. Write a JDBC program to insert all of the rows into the table.
  4. Write another JDBC program to time the query to find the day and volume when the volume is over 1,000,000,000 shares.
  5. Write an SQL statement to create an index on the volume field.
  6. Repeat the JDBC program