IEOR 115: Industrial and Commercial Data Systems

Instructor:

Prof. Ken Goldberg
Spring 1995
MW 11-12, B-1 NorthGate
F 1-3, 1173 Etcheverry

Course Description:

What do the IRS, PacBell, DMV, and UC Berkeley have in common?: they all manage huge databases of information that probably include data on you. 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 can be used by industry.

Tentative Schedule

WeekLectureLab
Jan 15IntroductionWWW
Jan 22Basic ConceptsMS Access
Jan 29Basic Concepts, Data ModellingDP Update
Feb 05Data ModellingMS Access
Feb 12Relational AlgebraDP Update
Feb 19Relational AlgebraMS Access
Feb 26Structured Query LanguageDP Update
Mar 04Structured Query LanguageSybase
Mar 11DP Progress ReportsSybase
Mar 18Mid-TermDP Project
Mar 25Spring break
Apr 01Normalization TheoryMS Access
Apr 08Normalization TheoryDP Update
Apr 15Query OptimizationDP Project
Apr 22Distributed DatabasesMS Access
Apr 29DP ReviewDP Review
May 6DP Review, DP Jury (May 8)

Administration:

Professor    Ken Goldberg
  	     4189 Etcheverry Hall
	     (510) 643-9565
	     goldberg@ieor.berkeley.edu

	     Office Hours: T 3-5, F 11-12, or by appointment.

Teaching     Osama Qasem
Assistant    4193 Etchevarry Hall
	     (510) 664-3020
	     qasem@ieor.berkeley.edu

     	     Office Hours: W 1-2 in Etcheverry 4193 or by appointment.

Textbooks

Required:    1. R. A. Elmasri and S. B. Navathe, Fundamentals of Database Systems
		Second Edition.  Benjamin/Cummings, 1994.
         
	     2. Selected Readings (to be handed out in class).

Optional:    1. C. J. Date,    An Introduction to Database Systems
                Sixth Edition.  Addison-Wesley, 1995.
         
     	     2. Wired magazine

Grading will be based on:

	25%  Homeworks and Labs
	25%  Mid-Term Exam
	50%  Design Project (Oral and Written)