Administrivia
Professor Ken Goldberg
Email: goldberg@ieor.berkeley.edu
Office Hours: Monday Wednesday 5:00pm-6:00pm 4189 Etcheverry Office hours also by appointment.
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.
Course Information
Industrial Engineering and Operations Research Department IEOR 215
Course Dates: August 30 to December 15, 2004
Lecture Schedule: Monday Wednesday 2:00pm-3:00pm in 3111 Etcheverry Hall
Lab Schedule: Friday 2:00pm-3:00pm in 3106 Etcheverry Hall
Units: 3
Grading Option: Letter Grade only
Course Texts
Required
Fundamentals of Database Systems, R. A. Elmasri and S. B. Navathe. Addison Wesley, 2003. ISBN: 0321122267
Be sure to get the fourth edition.
Optional
Access Database: Design and programming, 3rd ed., S. Roman. O'Reilly Press, 1999. ISBN: 0596002734
Course Resources
Access
Microsoft (MS) Access is a commonly used commercial database program available on the IEOR lab machines. I expect you to learn this on your own, at your own pace, using the Lab Handouts and Quizzes available on the 215 website. General questions on MS Access will be included in the midterm and final.
Constructive Criticism
I welcome constructive criticism. Please email me with feedback on the course, teaching and format at any time during the term.
A list of the MS Access Labs.
Database Security Presentation (.ppt)
Object Oriented Database Presentation (.ppt)
Spatial Databases Presentation (.ppt)
Database Transactions and Recovery Presentation (.ppt)
Grading Criteria
10% Class Participation, Homework and Lab Quizzes
20% Team Project 1
20% Team Project 2
20% MidTerm Exam
30% Final Exam
Course Work
September 1 : Wednesday
September 3 : Friday
Resources
Due on September 20
September 8 : Wednesday
September 13 : Monday
Due on September 27
Due on September 20
September 17 : Friday
Resources
Due on September 27
September 20 : Monday
September 27 : Monday
September 29 : Wednesday
October 4 : Monday
October 5 : Tuesday
October 6 : Wednesday
Due on October 18
October 12 : Tuesday
October 19 : Tuesday
October 22 : Friday
Due on October 27
November 1 : Monday
December 6 : Monday
last updated on 2004-09-29 by Lisa