IEOR 115 Syllabus

IEOR 115: Industrial and Commercial Data Systems

Fall 2002 Syllabus
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept
University of California at Berkeley
Lectures: MW 11-12pm, 3113 Etcheverry
Labs: F 10-12pm, 1173 Etcheverry
Web Page: www.ieor.berkeley.edu/~goldberg/

This course explores how databases are designed, implemented, used and maintained, with an emphasis on industrial and commercial applications. We focus on the relational database model and learn the mathematics of structured queries. Students will gain experience with MS Access, a commercial database management system, and will work in teams with local organizations to design and implement a prototype database system in the team Design Project (DP).

Administration

Professor: Ken Goldberg, 4189 Etcheverry Hall. goldberg@ieor.berkeley.edu. Office Hours: M 3-4, W 4-5, or by appointment.
Teaching Assistant: Yoek-Nam Khor, ykhor@ieor.berkeley.edu. Office Hours: F 9-10am in the Lab.
Grader: Zhijie Huang: zhuang@uclink.berkeley.edu. To discuss homework or lab grades, please contact the Teaching Assistant first.
Lab Adminstrator: Jay Sparks sparks@ieor.berkeley.edu. By Appointment.
Textbook (required): R. A. Elmasri and S. B. Navathe, Fundamentals of Database Systems. NOTE: be sure to get the Third Edition! : Benjamin/Cummings, 1999.
Reference (NOT required! Available from Amazon.com): S. Roman, Access Database: Design and Programming. 2nd edition O'Reilly Press, 1999.
Other required readings will be handed out in class.
Grading: based on:
- 05% Class Participation
- 15% Homework
- 20% First Mid-Term Exam
- 25% Final Exam
- 35% Design Project (Oral and Written)
Other: I welcome constructive criticism. Please email me with feedback on the course, teaching and format at any time during the term.

Tentative Schedule

Week	Lecture Date	Topic	Lab Date	Description
1	Aug 26, 28	Introduction, History of RDMS	Aug 30	HTML Lab
2	Sept 2, 4	(Labor Day) Entrance Exam, Design Project	Sept 6	Access Lab 1
3	Sept 9, 11	Design Projects/ER and EER Models	Sept 13	Access Lab 2
4	Sept 16, 18	(Yom Kippur), DP Team Assignments	Sept 20	Access Lab 3
5	Sept 23, 25	Relational Algebra	Sept 27	Access Lab 4
6	Sep 30, Oct 2	Relational Algebra	Oct 4	DP Review 1
7	Oct 7, 9	Relational Algebra	Oct 11	Access Lab 5
8	Oct 14, 16	Structured Query Language	Oct 18	Design Project
9	Oct 21, 23	Structured Query Language	Oct 25	Design Project
10	Oct 28, 39	Structured Query Language	Nov 1	Design Project
11	Nov 4, 6	Review, Mid-Term	Nov 8	DP Review II
12	Nov 11, 13	Veteran's Day, Normalization	Nov 15	Access Lab 7
13	Nov 18, 20	Normalization Theory	Nov 22	MySQL Lab
14	Nov 25, 27	Normalization Theory	Nov 29	*Holiday (Thanksgiving)
15	Dec 2, 4	Normalization Theory	Dec 6	Final DP Presentations
16	Dec 9, 11	Reading Day, Final Exam (12:30-3:30, 180 Tan)/Final Report Due	Dec 13	--