ICS321 Data Storage & Retrieval (Fall 2015)

Course Syllabus

Instructor name and contact information.

Dr. Lipyeow Lim

POST 303E. 808-203-8018. lipyeow at hawaii dot edu

Course description.

Data storage devices, timing and capacity, programming for files, hashed and indexed files, introduction to relational database systems.

Course objectives.

Relationship to Program SLOs

(a) Students can apply knowledge of computing and mathematics appropriate to the discipline

(b) Students can analyze a problem, and identify and define the computing requirements appropriate to its solution

(c) Students can design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs

(i) Students can use current techniques, skills, and tools necessary for computing practice.

(j) An ability to use and apply current technical concepts and practices in the core information technologies. [BA IT only]

(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems. [BA IT only]

Number of credit hours

3 credit hours


ICS211 or consent

Textbooks & Required Readings

Database Systems: The Complete Book (2nd Edition). Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom. ISBN-13: 978-0-13-187325-4.

Grading and Student Evaluation

Grades will be released and maintained using Laulima Gradebook.

Typically only the top N quiz grades are counted towards the student’s final grade (N is around 16 out of 20). This ensures that any intermittent problems with taking the quiz due to networking issues, server issues, personal issues that are beyond the instructor’s control will not adversely affect the student’s final grade.

For both mid-term and final exams, two letter-size pages of notes are allowed (either 1 double-sided sheet or 2 single sided sheets). Notes can be handwritten or printed. Calculators are allowed. Internet access is NOT allowed.

Classroom policies

Late policy: work submitted past due date and time will receive zero credits.

Examinations: No make-up exams will be given.

Student Conduct: All students are expected to conduct themselves above and beyond the standard set forth in UH Systemwide Student Conduct Code.

Disability: 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 Liliuokalani Center for Student Services.

Weekly schedule of topics and readings, including exam dates.

  1. Introduction & Overview of Database Systems

  2. Relational Model of Data

  3. Algebraic & Logical Query Languages

  4. The Database Language SQL

  5. The Database Language SQL

  6. SQL in a Server Environment

  7. Midterm Review and Exam

  8. High-level Database Models: ER models

  9. Design Theory for Relational Databases: Functional dependencies

  10. Design Theory for Relational Databases: Normal Forms

  11. Constraints, Triggers, Views & Indexing

  12. Overview of Transaction Processing

  13. Overview of Storage & Indexing

  14. Overview of Query Processing & Optimization

  15. XML & Semi-structured Data Models

  16. Project Presentation

  17. Final Exam