IMPLEMENTATION PROCEDURE FOR ASSIGNMENT 3
STUDENT ID: 9975

Yu Cheng (Jade)
ICS 321 Assignment 3
December 18, 2008


[Introduction]
This assignment builds on Assignment 1 and 2, so all files from Assignment 1 and
2 must be executed before attempting to execute files from Assignment 3. I have
submitted Assignment 1, Assignment 2, and Assignment 3 for this reason.

The files are organized by assignment number.  All files from Assignment 1 are 
located in the HWA1 folder, all files from Assignment 2 are located in the HWA2
folder, and all files from Assignment 3 are located in the HWA3 folder.

All assignments reference all imported data from the T:\ drive.  I use at home
the SUBST command to map this drive to HWA1, HWA2 and HWA3.  For example, when
executing files from HWA1, I first execute this command from the command line:

C:\>SUBST T: "C:\Path\To\My\Files\HWA1"

Then, when I am done executing the SQL files from Assignment 1, I unmap it 
like this:

C:\>SUBST /D T:

I do the same thing before executing files from HWA2 and HWA3.

If this drive substitution is not done, the tester will need to manually edit 
my SQL files and change the folder locations accordingly.

Also, if the database from Assignment 2 has been removed from the tester's
computer, it will need to be recreated.  This can be done in one of two ways.
One possible way is to re-run all SQL scripts provided in this directory
structure.  If this is done, they should be executed in the order specified by
the homework assignment description.

The other way is to install the databases directly.  The backup database for
assignment 2 has been provided in the HWA2 folder.


[Step 1]
Procedure:
	Execute HWA3_P1_1.sql.
	Execute HWA3_P1_2.sql.
	Execute HWA3_P2_1.sql.
	Execute HWA3_P2_2.sql.
	Execute HWA3_P3_1.sql.

Discussion:
	This will update the database to its completed condition for Assignment 3.
	I did the homework assignment using scripts only, so there are no GUI 
	operations needed to accomplish Step 1.

	I have saved solution files for both ASP.NET web sites.  To view these files
	on another computer, the tester must either use the SUBST command to make
	T: the root of the HWA3 directory, or the tester must edit the .sln file
	and modify the appropriate paths.