Fall 2009 Syllabus
Lecture: MW
Lab: F
Web Page: www.ieor.berkeley.edu/~ieor115
Professor Ken Goldberg
425 Sutardja Dai Hall
goldberg [AT]
Office Hours: Mon
Course Description:
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.
Teaching Assistant: Chanut Boonsongsawat
Contact info: boonsongsawat [AT]
Office Hour: Mon 12:
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 an explanation, and put the assignment in Meysam's mailbox on the 4th
floor of Etcheverry Hall. To discuss homework or lab
grades, please contact the Graders or Teaching Assistant directly via email.
Lab Adminstrator:
Jay Sparks
sparks [AT] ieor [DOT]
Textbook (required):
Fundamentals of Database
Systems.
R. A. Elmasri and S. B. Navathe,
5th Edition: Benjamin/Cummings, 2006.
Software Reference (not required, available from Amazon.com):
S. Roman, Access Database: Design and Programming. 2nd edition, O'Reilly Press, 1999.
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. I welcome constructive criticism. Please email me with
feedback on the course, teaching and format at any time during the term.
|
Assignment |
Due
Date |
|
Individual Contact
Report |
Sept 2 |
|
Team Assignments |
Sept 9 |
|
Homework 1
/ Team Proposals |
Sept 21 |
Tentative Schedule (updates in red)
|
Week |
Lecture
Date |
Topic |
Lab
Date |
Description |
|
1 |
Aug 26 |
Entrance
Exam, Overview, Formal Logic |
Aug 28 |
No Lab |
|
2 |
August
31, Sep 2 |
Formal
Logic |
Sep 4 |
Lab 1: Intro
to Microsoft Access (MSA) |
|
3 |
Sep 7,
9 |
(Labor
Day) ER and EER Models |
Sep 11 |
Lab 2:
MSA Tables |
|
4 |
Sep 14,
16 |
Relational
Algebra |
Sep 18 |
Lab 3:
MSA Relationships |
|
5 |
Sep 21,
23 |
Relational
Algebra |
Sep 25 |
Lab 4:
MSA Forms & Reports |
|
6 |
Sep 28,
30 |
Work on
DP |
Oct 2 |
DP
Review I ( |
|
7 |
Oct 5,
7 |
EER to
Relational Design Conversion |
Oct 9 |
Lab 5:
MSA Forms Plus |
|
8 |
Oct 12,
14 |
Work on
DP |
Oct 16 |
Lab 6:
MSA Macros / Modules |
|
9 |
Oct 19, 21 |
Relational
Algebra Operation |
Oct 23 |
DP
Review II |
|
10 |
Oct 26, 28 |
Structured
Query Language |
Oct 30 |
Lab 7:
MSA Queries - SQL |
|
11 |
Nov 2,
4 |
Structured
Query Language |
Nov 6 |
No Lab |
|
12 |
Nov 9, 11 |
Mid-Term
Review (Veteran's Day) |
Nov 13 |
No Lab |
|
13 |
Nov 16 Nov 18 |
Mid-Term,
Functional
Dependency |
Nov 20 |
Review
of Mid-Term |
|
14 |
Nov 23,
25 |
Functional
Dependency, Work on DP |
Nov 27 |
Thanksgiving
|
|
15 |
Nov 30,
Dec 2 |
Minimum
Cover, Candidate Key Algorithms |
Dec 4 |
DP team
meetings |
|
16 |
Dec 7,
9 |
Reading
and Review Days |
Dec 11 |
Final
DP Presentations |