IEOR 115 Syllabus

IEOR 115: Industrial and Commercial Data Systems

Fall 2006 Syllabus (Tentative)
Professor: Ken Goldberg
Industrial Engineering and Operations Research (IEOR) Dept
University of California at Berkeley
Lecture: MW 2-3, 3106 Etcheverry Hall,
Lab: F 2-3, 1173/1174B Etcheverry Hall
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: 1:15-2pm, or by appointment.
Teaching Assistant: TBA. Office Hours: TBA. Late HW should be put in her IEOR mailbox on 4th floor of Etcheverry Hall.
Graders: TBA

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 approprieat mailbox as specified above. To discuss homework or lab grades, please contact the Graders or Teaching Assistant directly via email.

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)

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.
Other: I welcome constructive criticism. Please email me with feedback on the course, teaching and format at any time during the term.

Tentative Schedule (check website for updates!)

Week Lecture Date Topic Lab Date Description

1 Aug 28, Aug 30 Entrance Exam, Overview, Formal Logic Sep 1 Lab 1: Microsoft Access (MSA) Intro

2 Sept 4, 6 (Labor Day), Formal Logic, Individual Contact Reports Due Sept 8
Access Lab 2: MSA-Tables

3 Sept 11, 13 ER and EER Models, Design Team Assignments Sept 15
No Lab:

4 Sept 18, 20 Relational Algebra, DP Team Proposals Due Sept 22 Access Lab 3: MSA Relationships

5 Sept 25, 27 Feedback on DP Proposals; Relational Algebra Sep 29 DP Review I

6 Oct 2, 4 (Yom Kippur), EER to Relational Design Conversion, revised EER proposals due Oct 6 Access Lab 4: MSA Forms and Reports

7 Oct 9, 11 Relational Algebra Oct 13 Access Lab 5: MSA Forms Plus

8 Oct 16, 18 Relational Algebra Operators Oct 20 Access Lab 6: MSA Macros-Modules-Internet

9 Oct 23, 25 Structured Query Language Oct 27 DP Review II

10 Oct 30, Nov 1 Structured Query Language Nov 3
Access Lab 7: MSA Queries-SQL

11 Nov 6, 8 Mid-Term Review, Mid-Term Nov 10 DP team meetings

12 Nov 13, 15 Functional Dependency Nov 17 DP: team meetings

13 Nov 20, 22 DP Review III (written) due; Inference Rules Nov 24 Thanksgiving Holiday

14 Nov 27, Nov 29 Minimum Cover, Candidate Key Algorithms
Dec 1 DP: team meetings

15 Dec 4, 6 Normalization Theory: Review of Practice Midterm Dec 8 Final DP Presentations

16 TBA
Final Exam
Final Report Due

--

Week	Lecture Date	Topic	Lab Date	Description
1	Aug 28, Aug 30	Entrance Exam, Overview, Formal Logic	Sep 1	Lab 1: Microsoft Access (MSA) Intro
2	Sept 4, 6	(Labor Day), Formal Logic, Individual Contact Reports Due	Sept 8	Access Lab 2: MSA-Tables
3	Sept 11, 13	ER and EER Models, Design Team Assignments	Sept 15	No Lab:
4	Sept 18, 20	Relational Algebra, DP Team Proposals Due	Sept 22	Access Lab 3: MSA Relationships
5	Sept 25, 27	Feedback on DP Proposals; Relational Algebra	Sep 29	DP Review I
6	Oct 2, 4	(Yom Kippur), EER to Relational Design Conversion, revised EER proposals due	Oct 6	Access Lab 4: MSA Forms and Reports
7	Oct 9, 11	Relational Algebra	Oct 13	Access Lab 5: MSA Forms Plus
8	Oct 16, 18	Relational Algebra Operators	Oct 20	Access Lab 6: MSA Macros-Modules-Internet
9	Oct 23, 25	Structured Query Language	Oct 27	DP Review II
10	Oct 30, Nov 1	Structured Query Language	Nov 3	Access Lab 7: MSA Queries-SQL
11	Nov 6, 8	Mid-Term Review, Mid-Term	Nov 10	DP team meetings
12	Nov 13, 15	Functional Dependency	Nov 17	DP: team meetings
13	Nov 20, 22	DP Review III (written) due; Inference Rules	Nov 24	Thanksgiving Holiday
14	Nov 27, Nov 29	Minimum Cover, Candidate Key Algorithms	Dec 1	DP: team meetings
15	Dec 4, 6	Normalization Theory: Review of Practice Midterm	Dec 8	Final DP Presentations
16	TBA	Final Exam Final Report Due		--