CMSI 486
Introduction to Database Systems
Fall 2012
- Note
- This page is maintained as an archival record of the course shown above, and as such, some links on this page may no longer be valid nor accessible. They are kept here as a record of the resources that were available at the time of the course offering.
- Syllabus
- Headmaster: Where you’ll find our sample-but-real application
Assignments
- Assignment 0906: 1c, 3a, 4a, 4c, 4d, 4e, 4f
- Assignment 0918: 1a, 3a, 3d, 4d, 4e, 4f
- Assignment 1011: 1a–1c, 3b–3d, 4a–4f
- Assignment 1023, 1025
- Assignment 1023: 1a–1c, 3b–3d, 4a–4f
- Assignment 1025: 1a, 3d, 4a–4e
- Assignment 1101, 1108, 1115, 1129: 1a–1c, 3b–3d, 4a–4f
Handouts
- 0827: PostgreSQL Quick Start
- 0904: SQL
- 0906: Modern Web Sites, Annotated (Prezi)
- 0911: Headmaster Project Setup, Headmaster Service API
- 0913: Introduction to Data Modeling, UML Specification by Example 1: Use Cases, UML Specification by Example 2: Data Models
- 1002: The Relational Data Model: Structure (LaTeX source), Mapping Data Models to a Relational Database
- 1008: The Relational Data Model: Fundamental Operations (LaTeX source)
- 1023: The Relational Data Model: Additional Operations (LaTeX source)
- 1112: Quick takes
- 1119: The End of a DBMS Era (Might be Upon Us)
Related External Links
These links take you to web sites beyond this server. The sites are in no particular order or bias, just as they came to mind.
- Wikipedia: A good starting point for virtually any concept lookup
Software
- The PostgreSQL home page: An
industrial-strength, open source database management system
- Go to http://jdbc.postgresql.org to access PostgreSQL’s JDBC Driver.
- The Hibernate home page:
Object-relational mapping between Java and a relational database system
- The Hibernate Annotations reference will be of particular interest in this course.
- Jersey will wrap our databases in a RESTful way… (see below)
- …to be served up by Apache Tomcat over the web
Background Reading
- As seminal as they get: E. F. Codd’s A Relational Model of Data for Large Data Banks, Communications of the ACM 13(6), June 1970
- There is no shortage of material on SQL, so may as well start with its Wikipedia page
- Not strictly database-related, but useful: Roy Fielding’s doctoral dissertation, which introduced Representational State Transfer (REST) to the world
- In case you’ve never seen it, here’s RFC 2616—the HTTP/1.1 specification (note the first author)