ICS 321 Data Storage and Retrieval (Fall 2012)
General Information
- Class Meets: Mon and Wed 12pm - 1:15 pm MSB 114
- Final Exam : Mon Dec 10 12-2 pm (No make up exam)
- Instructor : Lipyeow Lim
- Instructor Office Hours : MW 1:30-2:30 pm POST 303 E or by appointment 808-956-3495
-
Teaching Assistant: Dylan Kobayashi ( dylank at hawaii dot edu ) POST 303-3
-
TA Office Hours : M 3-4pm W 4-5pm or by appointment
-
Textbooks:
-
(Required)
Database Systems: The Complete Book (2nd Edition).
Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom.
ISBN-13: 978-0-13-187325-4.
Book Website
-
(Alternate) You may also use A First Course in Database Systems (3nd Edition).
Jeff Ullman, and Jennifer Widom.
-
(Previous)
Database Management Systems, Third Edition.
Raghu Ramakrishnan and Johannes Gehrke.
ISBN: 0-07-246563-8. Book Website.
- Student Learning Outcomes: At the end of this class, the successful
student would
- have a broad understanding of database concepts and
database management system software
- have a high-level understanding of
major DBMS components and their function
- be able to model an application's data requirements using conceptual
modeling tools like ER diagrams and design database schemas based on
the conceptual model.
- be able to write SQL commands to create tables and indexes,
insert/update/delete data, and query data in a relational DBMS.
- be able to program a data-intensive application using DBMS APIs.
- experience working in a team on a database related project
- Late policy: work submitted past due date and time will receive zero credits.
-
All students are expected to conduct themselves above and beyond the standards set forth in the University of Hawaii Systemwide Student Conduct Code.
-
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)
- 15 % Quizzes
- 15 % Homework
- 40 % Project
- 15 % Mid-term exam
- 15 % Final Exam
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 Saturday 11AM to Monday 11AM.
| Week |
Date |
Topic |
Readings |
Remarks
|
Software Setup
Other Readings
Videos
Useful Links