IEOR 115 Syllabus

IEOR 115: Industrial and Commercial Data Systems

Fall 2004 Syllabus
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept
University of California at Berkeley
Lecture: MW 11-12, 180 Tan Hall
Lab: F 12-2, 3106 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 to design and implement a prototype database system for a local organization.

Administration

Professor: Ken Goldberg, 4189 Etcheverry Hall. goldberg@ieor.berkeley.edu. Office Hours: MW 5-6pm, or by appointment.
Teaching Assistant: Xiao-yan Liu Office Hours: F 11-12pm in the Lab.
Grader: Abham Mumbare and Veronica Vela. To discuss homework or lab grades, please contact the Teaching Assistant first. Late homeworks: Mark LATE [DATE] on top and put into grader's mailbox on 4th Floor Etcheverry Hall.
Lab Adminstrator: Jay Sparks sparks@ieor.berkeley.edu. By Appointment.
Textbook (required): R. A. Elmasri and S. B. Navathe, Fundamentals of Database Systems. Fourth Edition. : Benjamin/Cummings, 2003.
Software 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% Homeworks and Lab Quizzes
- 20% First Mid-Term Exam
- 25% Final Exam
- 35% Design Project (Presentations and Reports)
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 30, Sep 1	Entrance Exam, Intro	Sep 3	Lab 1: Intro
2	Sept 6, 8	(Labor Day), Design Project	Sept 10	Access Lab 2
3	Sept 13, 15	Formal Logic	Sept 17	Access Lab 3
4	Sept 20, 22	ER and EER Models, Design Team Assignments	Sept 24	Access Lab 4
5	Sept 27, 29	Relational Algebra, Feedback on DP Proposals	Oct 1	Access Lab 5
6	Oct 4, 6	Relational Algebra	Oct 8	Access Lab 6
7	Oct 11, 13	ER and EER to Relational Design Conversion	Oct 15	Access Lab 7
8	Oct 18, 20	Relational Algebra Operators	Oct 22	DP Review 1
9	Oct 25, 27	Structured Query Language	Oct 29	Access Lab 8
10	Nov 1, 3	Structured Query Language	Nov 5	Design Project
11	Nov 8, 10	Mid-Term Review, Mid-Term	Nov 12	Design Project
12	Nov 15, 17	Functional Dependency	Nov 19	DP Review II
13	Nov 22, 24	Inference Rules	Nov 26	Thanksgiving Holiday
14	Nov 29, Dec 1	Min Cover, Candidate Key Algorithms	Dec 3	Design Project
15	Dec 6, 8	Normalization Theory	Dec 10	Final DP Presentations
16	Dec 14	Final Exam, Tues 12:30-3:30pm, C230 Cheit Hall Final Report Due		--