IEOR 115 Syllabus

IEOR 115: Industrial and Commercial Data Systems

Spring 2001 Syllabus
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept
University of California at Berkeley
Lectures: MW 12-1, 3113 Etcheverry
Labs: F 2-4, 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 a commercial database management system and will work in teams with local companies on a Design Project (DP) . Since the World Wide Web (WWW) is essentially a huge distributed multimedia database, we'll also learn how to design HTML pages, how to search and collect data on the web, and how the WWW is being used by industry.

``Student teams from two IEOR database design courses recently placed their semester projects up for review before local technical gurus. Two juries of engineering professors and industry representatives rated the Web-based projects on the basis of creativity, database design, technical sophistication, functional richness, and user interface design.'' -- Tamar Laddy, UCB Engineering News, 1996.

Administration

Professor: Ken Goldberg, 4189 Etcheverry Hall. goldberg@ieor.berkeley.edu. Office Hours: MW 4-5, or by appointment.
Teaching Assistant: Yoek-Nam Khor
ykhor@ieor.berkeley.edu. Office Hours: F 1-2 in the Lab.
Grader: 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): 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	Jan 17	Introduction, History of RDMS	Jan 19	Access Lab 1
2	Jan 22, 24	ER and EER Diagrams	Jan 26	Access Lab 2
3	Jan 29, 31	Design Projects/Team Assignments	Feb 2	HTML
4	Feb 5, 7	Relational Algebra	Feb 9	Access Lab 3
5	Feb 12, 14	Relational Algebra	Feb 16	Access Lab 4
6	Feb 19, 21	President's Day/Relational Algebra	Feb 23	DP Review I
7	Feb 26, 28	Relational Algebra	Mar 2	Access Lab 5
8	Mar 5, 7	Structured Query Language	Mar 9	Design Project
9	Mar 12, 14	Structured Query Language	Mar 16	DP Review II
10	Mar 19, 21	Structured Query Language	Mar 23	Design Project
11	Mar 26, 28	Spring Break	Mar 30	Spring Break
12	Apr 2, 4	Review, Mid-Term	Apr 6	Access Lab 6
13	Apr 9, 11	Normalization Theory	Apr 13	DP Report III due
14	Apr 16, 18	Normalization Theory	Apr 20	Access Lab 7
15	Apr 23, 25	Normalization Theory	Apr 27	Design Project
16	Apr 30, May 2	Normalization, Final Project Presentations	May 4	No Lab
17	May 7	Final Project Presentations	--	--
18	May 15	Final Exam: 12:30-3:30, 141 McCone Hall	--	--