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.
