Analysis and Design of Databases

Info
258

3 units

Warning message

This course is not currently offered.

Course Description

 

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

 

 

Prerequisites

Graduate standing or approval of instructor.
Last updated: April 11, 2022