CSc 4710/6710 (Spring 2000) Home Page

CSc 4710/6710, Database Systems
Spring 2000

CSc 4710/6710 Bulletin Board
Course Syllabus
SQL Tutorial
A Simple Guide to Oracle SQLPlus
Project Groups
Project (Phase I); Due: 17 February, 2000.
Project (Phase II); Due: 23 March, 2000.
Project (Phase III); Due: 4 May, 2000.
Graduate Students Paper Requirement. Due: 4 May, 2000.
Gradebook; View your scores here.

To compile Pro*C/C++ programs, you will need the proc.mk makefile. Please copy this from ~raj/proc.mk into your working directory.
Homework Assignments.
Additional Data for HW4.
SQL Script for HW5 (Bill of Materials).
SQL Script for HW6 (Portfolio Database).
SQL Script; Exam 2 Students Database.
SQL Script; Exam 2 Suppliers Database.
Practice Problems for Exam3. NEW!

Hw5,6 Submission: You should transfer the source and executable files (BOM.java, BOM.class, port.pc, and port) via anonymous ftp on zeus.cs.gsu.edu in the directory
```
pub/raj/4710/lastname
```
In case your lastname is not unique (liu and shi), the directory is
```
pub/raj/4710/lastname-firstname
```
Company Database SQL Schema.
Company Database Insert Statements.
Chapters 1 and 2 Transparencies (pdf, ps)
Chapters 3 Transparencies (pdf, ps)
Chapters 7 Transparencies (pdf, ps)
Chapters 7 Queries (pdf, ps)
ER to Relational Schema Transformation (pdf, ps)
Oracle8 Primer - Chapter 1 Transparencies (pdf, ps)
SQL Transparencies (pdf, ps)
JDBC Transparencies (pdf, ps)
Pro*C Transparencies (pdf, ps)
Chapter 9 Notes (TRC, DRC, Datalog)

Page Maintained by raj@cs.gsu.edu