Any student who feels s/he may need an accommodation based on the impact of a
disability is invited to contact the instructor privately. The instructor would
be happy to work with you, and the KOKUA Program (Office for Students with
Disabilities) to ensure reasonable accommodations in the course. KOKUA can be
reached at (808) 956-7511 or (808) 956-7612 (voice/text) in room 013 of the
Queen Lili'uokalani Center for Student Services.

Pre-requisites: ICS 211 Intro to CS II or consent.

Topics

Ch 1. The Worlds of Database Systems ~10p

Ch 2. The Relational Model of Data ~50p

Ch 3. Design Theory for Relational Databases ~60p

Ch 4. High-Level Database Models ~70p

Ch 5. Algebraic and Logical Query Languages ~40p

Ch 6. The Database Language SQL ~60p

Ch 7. Constraints and Triggers ~20p

Ch 8. Views and Indexes ~20p

Ch 9. SQL in a Server Environment ~50p

Ch 11. The Semi-structured Data Model ~20p

Ch 12. Programming Languages for XML ~30p

Ch 13.{0-2}, Ch 14.{0-2}. Overview of Storage and Indexing

Ch 16.1, Ch 15.{0-3}. Overview of Query Processing

Ch 18.{0-2}, Ch 17.1. Overview of Transaction Processing

Grading (Tentative)

Class Schedule (tentative)

The weekly quizzes will be administered as timed quizzes using the Test and
Quizzes section of Laulima. Each quiz will consists of 10 multiple choice
questions to be answered in 30 minutes. You may take each quiz only once
anytime within the window between Sunday 11AM to Monday 11AM.

In general, you
should make use of the install documentation (eg. the free Getting
Started with DB2 Express-C book) and the DB2 forums. There is also
comprehensive documentation on the DB2 commands etc at the DB2
Information Center. Part of learning how to use a DBMS software is navigating the documentation that comes with the software.

Mac OS: Note that if you're installing the beta for Mac OS, you should
check the forum for configuration instructions if the install has
problems. XCode is required (thanks to Kevin Leong).