SAINT MARY'S UNIVERSITY
Department of Mathematics and Computing Science
CSC 677.1: Intelligent Data Mining
SUMMER 2002

Assignment #1

Due Date: Tuesday, July 9, 2002 (Before the class begins)

Use DB2 to create a table of customers as follows:

House Visits for 26 weeks (26 columns) Spending for 26 weeks (26 columns)

You only need to submit:

  1. the set of SQL commands that you used to create the table
  2. screenshots of the retrieval process and resulting tables (do not try to print the entire table).