This course covers database systems from the perspective of database designers and programmers, different from database system implementers. The emphasis is on fundamental topics that should be familiar to every computer scientist and good programmer. In addition to traditional topics such as Entity-Relationship modeling, relational database design theory, relational algebra and calculus, SQL, and Datalog, the course also covers object-oriented and object-relational databases, with topics such as ODL, OQL, and SQL3.

News and Reminders:

• Please read the newsgroup for timely announcements.
• Class newsgroup: Local group umaine.cos480 on NNTP server news.cs.umaine.edu. Web interface to get started: http://cs.umaine.edu/~chaw/news/.
• The most recent version of this document may be found at http://cs.umaine.edu/~chaw/cos480/.
• Some sections below point to material in separate documents that are found on the class Web site, linked from the online version of this document.
• You may access a local copy of the PostgreSQL documentation (with a slightly improved formatting) at pgsql/doc/html/. In particular, the section describing psql is at pgsql/doc/html/app-psql.html.
• Please use the PDF version of this document for printing and reference: cos480.pdf

© 2010 Sudarshan S. Chawathe