Read this assignment thoroughly before you proceed. Failure to follow instructions can affect your grade.
data mining
Description
Instructions
1. Read this assignment thoroughly before you proceed. Failure to follow instructions can affect your grade.
2. Download the database schema a2.ddl from the course website.
3. Download the file a2.sql from the course website.
4. Download the java skeleton file Assignment2.java from the course website.
5. Submit your work electronically using UNIX submit. Your submission must include the following files:
a) a2.sql your queries for the interactive SQL part of the assignment (can include any view creation statement). If you define any views for a question, you must drop them after you have populated the answer table for that question.
b) Assignment2.java your java code for the embedded SQL part of the assignment. Be careful to submit the .java file (not the .class file.). To get you started, we provide a skeleton of this file that you must download from the assignment webpage. Also, make sure that your java file does not include any main() function.
c) team.txt a file that includes information about the team members (first name, last name, student ID, login, yorku email).
