ICS321 is an introductory data management course covering data modeling, database systems, SQL, database-backed application development, transaction processing, indexing, query processing & optimization. For more information, please consult the syllabus.
Instructor: Lipyeow Lim. POST 303E. Office Hours Wed 2-4pm. 808-956-3495. lipyeow at hawaii dot edu.
Teaching Assistant: Mariam Doliashvili. POST 303-4 Office Hours by Appointment on Skype/Google Hangout. mariamd at hawaii dot edu.
Final Exam: Thu May 10 12-2pm (No make-up exam)
Textbook: Database Systems: The Complete Book (2nd Edition). Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom. ISBN-13: 978-0-13-187325-4.
Communications: We will be using Piazza for questions and answers. Please post questions there so that the whole class can benefit.
Late policy: work submitted past due date and time will receive zero credits.
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.
Schedule
| Week | Date | Topic | Before Class | In Class | After Class |
|---|---|---|---|---|---|
| 1 | Tue Jan 9 | Introduction | Syllabus | Slides | HW1: Querying Large Files | |
| 1 | Thu Jan 11 | Worlds of Database Systems | Ch.1 | Quiz01 | Slides | Exercise 1 | Install DBMS Software |
| 2 | Tue Jan 16 | Virtualization | Slides | Docker Containers | ||
| 2 | Thu Jan 18 | The relational model of data | Ch.2 | Quiz02 | Slides | Exercise 2 | |
| 3 | Tue Jan 23 | The relational model of data | Ch.2 | Quiz03 | Slides | Exercise 3 | |
| 3 | Thu Jan 25 | Algebraic and logical query languages | Ch.5 | Quiz04 | Slides | Exercise 4 | HW1 due on Fri 23:59H. |
| 4 | Tue Jan 30 | Algebraic and logical query languages | Ch.5 | Quiz05 | Slides | Exercise 5 | |
| 4 | Thu Feb 1 | SQL | Ch.6 | Quiz06 | Slides | Exercise 6 | HW2: SQL |
| 5 | Tue Feb 6 | SQL | Ch.6 | Quiz07 | Slides | Exercise 7 | |
| 5 | Thu Feb 8 | SQL | Ch.6 | Quiz08 | Slides | Exercise 8 | |
| 6 | Tue Feb 13 | SQL in a server environment | Ch.9 | No Quiz | Slides | |
| 6 | Thu Feb 15 | Midterm - practice | No Quiz | Mock Midterm | |
| 7 | Tue Feb 20 | Midterm | No Quiz | Database Schema for Midterm | ||
| 7 | Thu Feb 22 | Oath Career Talk | No Quiz | ||
| 8 | Tue Feb 27 | SQL in a server environment | Ch.9 | Quiz09 | Slides | HW3: Web App |
| 8 | Thu Mar 1 | High-level database models | Ch.4 | Quiz10 | Slides | Exercise 10 | HW4: ERD |
| 9 | Tue Mar 6 | Design theory for relational databases | Ch.3 | Quiz11 | Slides | Exercise 11 | |
| 9 | Thu Mar 8 | Design theory for relational databases | Ch.3 | Quiz12 | Slides | Exercise 12 | |
| 10 | Tue Mar 13 | Design theory for relational databases | Ch.3 | Quiz13 | Slides | Exercise 13 | |
| 10 | Thu Mar 15 | Constraints, triggers, view, indexes | Ch.7-8 | Quiz14 | Slides | Exercise 14 | |
| 11 | Tue Mar 20 | Transaction processing | Ch.17.1.Ch.18.0-2 | Quiz15 | Slides | Exercise 15 | |
| 11 | Thu Mar 22 | Transaction processing | Ch.17.1.Ch.18.0-2 | Quiz16 | Slides | Project |
| 12 | Tue Mar 27 | Spring Break | |||
| 12 | Thu Mar 29 | Spring Break | |||
| 13 | Tue Apr 3 | Transaction processing | Ch.17.1.Ch.18.0-2 | Slides | Exercise 16 | |
| 13 | Thu Apr 5 | Storage and indexing | Ch.13.0-2.Ch.14.0-2 | Quiz17 | Slides | Exercise 17 | |
| 14 | Tue Apr 10 | Storage and indexing | Ch.13.0-2.Ch.14.0-2 | Quiz18 | Slides | Exercise 18 | |
| 14 | Thu Apr 12 | Query processing | Ch.16.1.Ch.15.0-3 | Quiz19 | Slides | Exercise 19 | |
| 15 | Tue Apr 17 | Special Topics-Blockchain | Slides | ||
| 15 | Thu Apr 19 | Data Warehousing | Slides | ||
| 16 | Tue Apr 24 | Non-relational Data Models | Slides | ||
| 16 | Thu Apr 26 | Project | |||
| 17 | Tue May 1 | Project |
About this site: Modules lists the topics covered. Learning outcomes collect all the desired student learning outcomes of all the modules. Readings list the “passive” learning opportunities like reviewing of textbook sections, web pages, screencasts, etc. Experiences list the “active” learning opportunities where you must actually demonstrate a capability.