IEOR 215: Analysis and Design of Databases

Spring 1997
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept,
University of California at Berkeley

Lecture: MW 2-3, 3109 Etcheverry
Lab: F 3-5, 1173 Etcheverry

In this graduate design course, we focus on the systematic design of databases and interfaces for commercial and industrial applications. The World Wide Web offers a new approach to accessing databases; many companies are actively developing intranets based on this technology. Teams of 3 students will collaborate on a semester-length research project to design and develop innovative WWW sites that allow users to interact with databases.

We focus on the relational database model, where a given set of data attributes can be arranged into many 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. As time permits, we will also investigate current research topics in the field, such as methods for referencing geometric data.

In the Lab, students will experiment with a commercial Database Management System and use Java to link it to the WWW. To supplement the textbook, we will read research papers and review WWW sites.

Spring 97 Team Research Projects

Lab Home Page

Relevant Sites

IEOR 215 Page from Spring 1996.

this page:
http://www.ieor.berkeley.edu/~goldberg/courses/S97/215/