tool to query the database

pdf file of the complete dataset

Welcome to our little CS127 outpost.

The university relation from the textbook has been converted
into a live, query-able database. All of the tables from the textbook
"university" relation are included. The data in each table have been sized to a
manageable quantity for study purposes, and have been checked for accuracy.
The output columns are named, so you can see where the data is coming from.
The first row is the name of the table, and the second row is the name of
the attribute. When you join several tables, it is helpful to see the table
name as well as the attribute name for each column.

Also, the entire database has been "printed out" as a pdf file.
Having the full dataset in front of you will help you reason about
the results you get from your queries.

The links at the top of this page take you to these resources.