Database Project: Episode Guide

The following was a quarter-long database project for the CS145 Databases class at Stanford University. I created an episode guide for my favorite television series: Star Trek: The Next Generation. On this site you can find the entity-relationship diagram and its translation to relations; an SQL schema and interaction with the database using SQL, including selection and modification, transactions, PL/SQL, stored procedures, views, and triggers; and finally PERL scripts used to build an interface to the database.
 


by Eric Silverberg - June 2000