CMSI 486T
Introduction to Database Systems
Summer 2011, Session II
- 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.
All materials are in PDF. Contact me directly for source code or solutions.
- Syllabus
- Supplementary Handouts
- PostgreSQL Quick Start
- Introduction to Data Modeling
- UML Specification by Example 1: Use Cases
- UML Specification by Example 2: Data Models
- Relational Data Model 1: Structure
- Relational Data Model 2: Fundamental Operations
- Relational Data Model 3: Additional Operations
- SQL
- Mapping Data Models to a Relational Database
- Database Programming: JDBC, Data Access Object Design Pattern
- Relational Database Design 1: Functional Dependencies and Normal Forms
- Relational Database Design 2: Functional Dependency Theory
- Database Application Design and Development
- Transactions, Concurrency, and Recovery
- Concurrency Control
- Database Recovery
- Indexing & Hashing
- Query Processing
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.”
- The PostgreSQL home page: an
industrial-strength, open source database management system
- Go to http://jdbc.postgresql.org to access PostgreSQL’s JDBC Driver
- Comparison between MySQL and PostgreSQL
- The Hibernate home page: object-relational mapping between Java and a relational database system
- Wikipedia: A good starting point for virtually any concept lookup