ICS 321 Data Storage and Retrieval (Fall 2014 CRN 71629)
Class Schedule (tentative)
- Quizzes will be administered as timed quizzes using the Test and
Quizzes section of Laulima BEFORE each class. 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 11AM the day before class
to 11AM the day of class.
| Week |
Date |
Topic |
Readings |
Videos |
Remarks
|
General Information
- Class Meets: Tue and Thu 12pm - 1:15 pm MSB 114
- Final Exam : Thu Dec 18 12-2 pm (No make up exam)
- Instructor : Lipyeow Lim
- Instructor Office Hours : TTh 1:30-2:30PM POST 303 E or by appointment 808-956-3495
-
Teaching Assistant: Robert Ward ( at hawaii dot edu ) POST 303-4
-
TA Office Hours : TBD 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
Software Setup
Other Readings
Videos
Useful Links
