CompSci 316 (Fall 2012):
Introduction to Database Systems

Course Information
Lecture Notes
Assignments
Tentative Syllabus
Programming Notes
Getting Started with the dbcourse Virtual Machine
Getting Started with Gradiance
PostgreSQL Notes
Using ra
JDBC Notes
Tomcat Notes
Django Notes
PHP Notes
XML Notes
Homework/Project Submission
Sakai (Grades/Project Discussion)

Using RA


RA is a simple relational algebra interpreter. It has already been installed for you on your virtual machine, and it is set up to connect to the local PostgreSQL server. So just log in and type ra at the shell prompt.

For details on how to use RA, please refer to the public RA homepage, but ignore the parts about getting RA and SQLite being the default---your installation is set up differently.

To create/restore the db-beers database in PostgreSQL (the SQLite version of which was used as a running example on the RA homepage), run "/home/dbcourse/examples/db-beers/setup.sh" from the shell.

Last updated Wed Sep 12 21:57:59 EDT 2012