About

Hours & Location:  TuTh 6:30 – 7:50PM  EH1200

Instructor: Phillip C-Y. Sheu, psheu@uci.edu

Website: https://eecs116.wordpress.com

Office Hours:  Friday 5:00-6:30PM

Exams:  Midterm – Tuesday 11/01 in class;  Final – Final Schedule

Course Description: Relational data model and query languages. Design, programming and management of relational databases. Advanced applications.

Prerequisites: EECS 114 or ENGRECE 144 or I&C SCI 23 or CSE 23

Text:  Database System Concepts, H.F. Korth,  A. Silberschatz, and S. Sudarshan, Sixth Edition, McGraw-Hill, 2010

Course Outline

1. Introduction
2. Relational Data Model
3. SQL
4. Advanced SQL
5. Other Relational Query Languages
6. Database Design and the E-R Model
7. Relational Database Design
8. Application Design and Development
9. Advanced Applications
10. Database Management Issues (Storage, Indexing, Query Processing, Concurrency Control, Recovery, etc.)

Grading: Homework Assignments (20%),  Mini-Projects (10%), Midterm (30%), Final (40%)