Lecture: MW 5-6, 3108 Etcheverry Hall
Lab: F 11-12, 1173 Etcheverry Hall
Teaching Assistant: Xingwei Wu
This graduate database course introduces tools and approaches for the systematic design of databases and interfaces for commercial and industrial applications. We focus on the relational database model, where data attributes are arranged into alternative designs. We use Chen's Entity-Relationship model to represent these alternatives and Normalization Theory to evaluate and improve designs. We also cover query languages such as relational algebra and SQL. We also investigate current research topics in the field, such as methods for referencing temporal, geometric, and encrypted data. In the lab, students experiment with a commercial Database Management System and in two projects, teams design and implement prototype database systems and research advanced topics.
NOTE: Due to the size of our lab, the class is limited to 40 grad students. Since it's difficult to determine the numbers at registration time, we will give a simple entrance exam to all interested students. Don't worry about studying for this, it's not a test of knowledge but of eligibility and enthusiasm.Students who miss the first week of classes will be admitted as space permits.
For general information please contact Dina Michail, the IEOR Student Affairs Officer, at: dina@ieor.berkeley.edu.