Announcements

04-17-2006 HW5 has been posted.
03-28-2006 The due date for HW4 is changed to April 4th. Exam2 date is changed to April 6th. 
03-16-2006 The due date for the Bonus Project is changed to March 28th. 
03-16-2006 HW4 has been posted.
03-13-2006 The definition of Prime Attribute should be: attribute that is a member of any key.

For Testing Lossless Join Decomposition, the subscripts of 'b' cannot be ignored.

03-01-2006 The Bonus Project has been updated.
02-27-2006 Here is the extra-credit-project.
02-27-2006 Following is the code segment which can be used to connect the Yamacraw database:

String url = "jdbc:oracle:thin:@yamacraw.cs.gsu.edu:1521:sid9i";
String userid="XXXXXX";
String password = "XXXXXX";
 
try {
          conn = DriverManager.getConnection (url, userid, password);
        } catch (SQLException e1) {
            out.println("Error connecting to Oracle:"+e1.getMessage());
            return;
       }
02-23-2006 For those who has problem with accessing the .bash_profile, create such a file under your home directory. Here is the contents of this file:
 
# Oracle Stuff
ORACLE_BASE=/usr/oracle/9i/m01/app/oracle;export ORACLE_BASE
ORACLE_HOME=/usr/oracle/9i/m01/app/oracle/product/9.0.1; export
ORACLE_HOME
ORACLE_SID=sid9i; export ORACLE_SID
PATH=$ORACLE_HOME/bin:/opt/sfw/bin:/usr/local/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/jdbc/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:$ORACLE_HOME/jlib/servlet.jar:
$ORA
CLE_HOME/rdbms/jlib/xsu12.jar:$ORACLE_HOME/lib/xmlparserv2.jar:.;export
CLASSPATH
02-23-2006 HW3 has been posted.
02-22-2006 Project has been posted.
02-20-2006 For 6710 students: Here is the format for the abstract of the term paper. You may also find this article helpful.
02-15-2006 After copying the .bash_profile to your home directory the first time, please activate (execute) the .bash_profile. There
are two ways:
1. log out the yamacraw machine and then log in again.
2. run "source .bash_profile" command.
02-14-2006 SQL tutorial.
02-10-2006 For (9) and (10) in HW2, only write the queries in SQL.
01-30-2006 Codd's paper: A Relational Model of Data for Large Shared Data Banks
01-17-2006 HW1 has been posted.
01-06-2006 Welcome to CSC4710/6710! This website is to be used by all the students in both CSC4710 and CSC6710. Please be sure to check the announcements once per day.