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
- Introduction
- Relational Data Model
- SQL
- Advanced SQL
- Other Relational Query Languages
- Database Design and the E-R Model
- Relational Database Design
- Application Design and Development
- Advanced Applications
- Database Management Issues (Storage, Indexing, Query Processing, Concurrency Control, Recovery, etc.)
Grading: Homework Assignments (20%), Mini-Projects (10%), Midterm (30%), Final (40%)
Advertisements