A Quick Relational Database Tour

This page gives you a tutorial-style walkthrough of a relational database, specifically PostgreSQL. The walkthrough assumes that you are at a Seaver 120 lab computer.

But first, a little leadoff cartoon: http://xkcd.com/327

Running PostgreSQL on the Lab Machines

1. Login to the computer as usual
2. Launch pgAdmin III
3. The pgAdmin III window starts with a hierarchical view on the left that starts with three layers:
   • Server Groups
     • Servers (1)
       • PostgreSQL 9.6 (localhost:5432)
4. Double-click on PostgreSQL 9.6 (localhost:5432) to connect to the database server
5. The password to start the server will be given in class