CSc 4710/6710 (Fall 2011) Home Page

CSc 4710/6710, Database Systems
Fall 2011

Course Syllabus
Oracle 10g Primer - Source code etc.
Laboratory Manual (to accompany Elmasri-Navathe text)
Secure Shell Client
Another lightweight SSH slient
INTRODUCTION
EN: Chapter 1 (Databases and Database Users)
EN: Chapter 2 (Database System Concepts and Architecture)
RELATIONAL DATA MODEL
Lab Manual - Chapter 2
EN: Chapter 3 (The Relational Data Model and Constraints)
EN: Chapter 6 (Relational Algebra and Calculus)
Homework 1 (Due: September 8, 2011 - Thursday)
SQL
EN: Chapter 4 (Basic SQL)
SUN: Chapter 2 (SQL)
EN: Chapter 5 (More SQL)
Homework 2 (Due: September 26, 2011 - Monday)
JDBC API (to access relational databases in Java)
JDBC API javadoc
Lab Manual - Chapter 3
SUN: Chapter 5 (JDBC)
JDBC Scrollable ResultSets
Oracle JDBC Drivers for Java 6
Homework 3 (Due: October 16, 2011 - Sunday)
Homework 4 (Due: November 6, 2011 - Sunday)
Homework 5 (Due: November 20, 2011 - Sunday)
ER Modeling
EN: Chapter 7 (ER Model)
EN: Chapter 8 (Enhanced ER Model)
EN: Chapter 9 (ER to Relational Mapping)
Homework 6 (Due: November 1, 2011 - Tuesday)
Homework 6b (Due: November 7, 2011 - Monday) - Strict Deadline
db4o
Lab Manual - Chapter 6
Homework 7 (Due: December 4, 2011 - Sunday)

XML
Lab Manual - Chapter 7
Homework 8 (Due: December 11, 2011 - Sunday)

6710 Project
6710 Project

Page Maintained by raj@cs.gsu.edu