Fall 2006 Syllabus
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept
University of California at Berkeley
Lecture: MW 5-6, 3108 Etcheverry Hall
Lab: F 11-12, 1173 Etcheverry Hall
Web Page: www.ieor.berkeley.edu/~goldberg/

In this graduate course, we focus on the systematic design of databases and interfaces for commercial and industrial applications. Lectures 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 introduce the relational algebra and SQL query languages. Student teams will complete a small Research Project on a current topic in information technology. Student teams will design and implement a relational database in the lab. To supplement the textbook, we will read papers and discuss advanced topics.

1. Professor: Ken Goldberg, 4189 Etcheverry Hall. goldberg@ieor.berkeley.edu. Office Hours: MW: 1:15-2pm or by appointment.
2. Teaching Assistant (GSI): Xingwei Wu, Office Hour: TBD.
3. Grader: TBD.
4. Homeworks and Lab Quizzes: Hardcopies will be collected in Class. Sorry, but due to class size we cannot accept emailed homeworks or quizzes. If you miss class for any reason, Mark LATE [DATE and TIME] on top with explanation, and put into grader's mailbox on 4th Floor Etcheverry Hall. To discuss homework or lab grades, please contact the Teaching Assistant first.
5. Lab Adminstrator: Jay Sparks mailto:sparks@ieor.berkeley.edu By Appointment.
6. Textbook (required): R. A. Elmasri and S. B. Navathe, Fundamentals of Database Systems. NOTE: be sure to get the Fourth Edition! : Benjamin/Cummings, 2003.
7. Software Reference (not required. Available from Amazon.com): S. Roman, Access Database: Design and Programming. 2nd edition O'Reilly Press, 1999.
8. Other required readings will be handed out in class.
9. Grading: based on:
   • 10% Class Participation, Homework
   • 20% Team Project 1 (Access Database Design)
   • 15% Team Project 2 (PHP/MySQL Database Design)
   • 35% MidTerm Exam
   • 20% Final Quiz
10. Microsoft (MS) Access is a commonly used commercial database program available on the IEOR lab machines. We expect you to learn this largely 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.
11. MySQL is a commonly used open source SQL database. PHP is a language for accessing MySQL through the web to make online databases. More details on this will be given in the labs.
12. I respect and will accommodate religious beliefs, disabilities, and other special circumstances. Please contact me in person with advance notice so that we can plan accordingly.
13. Other: I welcome constructive criticism. Please email me with feedback on the course, teaching and format at any time during the term.