Analysis and Design of Databases
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.
Sample syllabus: http://goldberg.berkeley.edu/courses/F06/215/IEOR215/
Note: This course is cross-listed with IEOR 215