ICS 321 Data Storage and Retrieval ( Spring 2015 CRN 84959)
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 24 hours before class
to the start time of class.
Week |
Date |
Topic |
Readings |
Videos |
Remarks
|
General Information
- Class Meets: Mon and Wed 9am - 10:15 am POST 127
- Final Exam : Mon May 11 7:30-9:30am (No make up exam)
- Instructor : Lipyeow Lim
- Instructor Office Hours : MW 1:30-2:30PM POST 303 E or by appointment 808-956-3495
-
Teaching Assistant: Jon Moroney ( jmoroney at hawaii dot edu ) POST 314-1 and Kendyll Doi (kendyll at hawaii dot edu) POST 314-3
-
TA Office Hours : Kendyll Tue 12:30-1:30pm and Wed 11am-12pm or by appointment. Jon, Jon MW 12-1pm, F 4-5pm.
-
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.
- 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
- 45 % Homework
- 20 % Mid-term exam
- 20 % Final Exam
Software Setup
Other Readings
Videos
Useful Links