Use Catalog_Work for common tasks with the sastest MySQL account.
Use your own database copies for testing and other task.
Keep in mind the latest database schema and MySQL tables descriptions posted on the home page when changes to the database are made.

MyConnection.java, Retriever.java and TestRetriever.java are available on arcib at:
/local_software/jakarta-tomcat-4.0.1/webapps/sas_G/WEB-INF/classes

Feel free to copy them to your own directories, use them and modify.

All CSC course are already in the COURSES table. There are two ways to add data to the database. Use Insert commands (for examples look at the latest MySQL tables descriptions posted on the home page) and batch upload files. (for examples look at the batch files for COURSES and MAJOR_REQ below). Feel free to add data to the database when you need it but make sure you understand the structure and that it works on your own copy first. Please save all entered input queries to files.

COURSES
The file(don't put any extra lines) used to populate with the fields in the following order: CourseID, CourseNumber, CourseNumberNew, CourseLetter, CourseCode, CourseName, Credits, LevelID, CrossList, PreReqList, CoReqList, PostReqList, DepartmentID, MajorID:

PREREQUISITE = 0 MEANS NO CrossListing PRE/POST/CO REQUIREMENT FOR THAT COURSE
, MEANS AND
/ MEANS OR

The Command used to populate:
LOAD DATA INFILE '/home/students/KichukoG/Catalog_Data/courses_CSC.txt' INTO TABLE Catalog_Work.COURSES;

MAJOR_REQ
The file used to populate with the fields in the following order: ID, Credits CourseList, MajorID
The Command used to populate:
LOAD DATA INFILE '/home/students/KichukoG/Catalog_Data/major_req_CSC.txt' INTO TABLE Catalog_Work.MAJOR_REQ;

I am also posting the file that I used to recreate my Catalog_G database.