IEOR 115 Syllabus

IEOR 115: Industrial and Commercial Data Systems

Fall 2003 Syllabus
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept
University of California at Berkeley
Lectures: MW 11-12pm, 3106 Etcheverry
Labs: F 12-2pm, 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: MW 2:15-3pm, or by appointment.
Teaching Assistant: Anne-Sophie Ducottet, ducottet_as@yahoo.fr. Office Hours: F 11-12pm in the Lab.
Grader: Anne-Sophie. 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. Third or Fourth 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 25, 27	Entrance Exam, Intro	Aug 29	Lab 1: HTML
2	Sept 1, 3	(Labor Day), Design Project	Sept 5	Access Lab 2
3	Sept 8, 10	Formal Logic	Sept 12	Access Lab 3
4	Sept 15, 17	ER and EER Models, Design Team Assignments	Sept 19	Access Lab 4
5	Sept 22, 24	Relational Algebra, Feedback on DP Proposals	Sept 26	Access Lab 5
6	Sep 29, Oct 1	Relational Algebra	Oct 3	Access Lab 6
7	Oct 6, 8	(Yom Kippur), Relational Algebra	Oct 10	DP Review 1
8	Oct 13, 15	ER and EER to Relational Conversion	Oct 17	Access Lab 7
9	Oct 20, 22	Structured Query Language	Oct 24	Access Lab 8
10	Oct 27, 29	Structured Query Language	Oct 31	Design Project
11	Nov 3, 5	Mid-Term Review, Mid-Term	Nov 7	DP Review II
12	Nov 10, 12	Functional Dependency	Nov 14	Design Project
13	Nov 17, 19	Inference Rules	Nov 21	SQL Lab
14	Nov 24, 26	Min Cover, Candidate Key Algorithms	Nov 28	*Holiday (Thanksgiving)
15	Dec 1, 3	Normalization Theory	Dec 5	Final DP Presentations
16	Dec 8, 10	Reading Day, Final Exam 12:30-3:30 in 180 Tan Final Report Due	Dec 12	--