EECS116/CS122A Introduction to Data Management

Hours & Location:  TuTh 5:00-6:20PM  EH1200

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

Website: https://semanticcomputing.wixsite.com/eecs116

Office Hours:  Wednesday 5:30-6:30PM, EH 4225

Teaching Assistants: Kyle Li (haosongl@uci.edu), OH: Tuesday 3-5 pm at EH 4405; Jimmy Shih (hsiangss@uci.edu) OH: Wednesday 1-3 pm at EH 4405

​

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

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-Project (10%), Midterms (40%), Final (30%)