CSE 3330/5330                      Summer 2008

Instructions on Project #2
==========================

10% of your total marks will be deducted for not following this instruction!!
Make sure to read the format.txt file.





1. Db files


-----------


13 data files are included and their formats are described in format.txt.


The data files use space as delimiter between attritubes.


No space is inside the attritube, so "New Jersey" becomes "NewJersey".


Assume the database provided is sufficient.


Follow the format and attritube names as stated.





2. Handin Procedure


-------------------


a. Use the name convention as described below for the files that you will turn in.


Include all the files in a LastName1_LastName2_Px.zip archieve before sending them by email.
	ex) Gautam_Kim_P1.zip (for Part 1), Gautam_Kim_P2.zip (for Part 2), Gautam_Kim_P3.zip (for Part 3)



The answer files of part 1:


	EER diagram should be named 1_eer.xxx,


	explanations (if any) should be named 1_exp.xxx (xxx: see 2c below);


and that for part 2:


	schema should be named 2_schema.xxx,


	sql for creating all the tables should be named 2_create.sql,


	sql for dropping all the tables should be named 2_drop.sql,


	explanations (if any) should be named 2_exp.xxx (xxx: see 2c below);


and that for part 3:


	question 1 should be named:


	3_1.sql (the SQL script file executed in SQLPLUS)


	or


	q3_1.java (the main java file to invoke the program),


	or


	3_1 (please provide an automated shell scripts if you use other tools to load the data and included the extra files required)


	question 2 should be named:


	q3_2.java (the main java file to invoke the program),


	question 3 should be named:


	3_3.sql (the SQL script file executed in SQLPLUS)


	and


	3_3.txt (results),


	question 4 should be named:


	3_4.sql (the SQL script file executed in SQLPLUS)


	and


	3_4.txt (results),





b. Include all the files in a LastName.zip archieve (named it with your last name) before sending them by email.


Write a readme on how to compile and run your files.


Provide the file listing in the readme file also.





c. For part 1 and 2,


it is encouraged that you handin soft copy diagram in standard image format or document format.


(eg. .gif, .jpg, .doc, .pdf, ...)





d. For part 3, include all the .sql and .java.


Also, the ORDER (Alphabetical) of the output of the queries are VERY IMPORTANT.


Don't assume the order is correct inside the data files.





e. Assume all the database files in txt format locate in the current directory with your java program(s).






3. Handin Schedure
--------


- Part 1: Monday July 21, 2008
- Part 2: Monday July 28, 2008
- Part 3: Thursday August 7, 2008


