Home
Announcements
Class Web Page
Web Board
Schedule
Staff
Prerequisites
Text and Syllabus
Project
Reading List
Course Policies

Database System Applications
CSE132B Winter 2012

The following lines will contain new announcements, mostly around the project assignment. Weekly additions will be indicated.

• Welcome!
• The take-home final is out. It is due back on Tuesday, March 20 at midnight. Slide a hardcopy under my door (CSE 3238).

Class Web Page

Lecture notes, problems sets and many announcements will be available on this site. A substantial part of the site will be in HTML, PDF and PS formats. Please configure your browsers accordingly. It will not be the TAs' or the instructor's job to help you to do that. Please check the web page often, especially before the exams. You can download Adobe Acrobat Reader 8.1 by clicking here.

Schedule

	Mon	Tue	Wed	Thu	Fri
Lecture	3:00 pm - 3:50 pm Peterson 104		3:00 pm – 3:50 pm Peterson 104		3:00 pm – 3:50 pm Peterson 104
Discussion			10:00 – 10:50 WLH 2204
TA Office Hours
Instructor Office Hours	3:50pm – 4:50 pm EBU3b 3238 and by appointment

Staff

• Instructor: Alin Deutsch (deutsch at cs dot ucsd dot edu)
• TA: Nathan Bales (nbales at cs dot ucsd dot edu)

Prerequisites

• Java (8B or 11 or equivalent)
• SQL (132A or equivalent)

Text and Syllabus

NONE required. The following are (equally) recommended:

• First Course in Database Systems by Jeffrey D. Ullman and Jennifer Widom, Prentice-Hall.
• Database System Concepts by A. Silberschatz, H.F. Korth and S. Sudarshan

Reading List

Some class slides:

• E/R Model
• ODL
• Schema Design and Normal Forms
• SQL -- Data Definition Language (Includes Integrity Constraints)
  
• SQL -- Update Language
• SQL -- Query Language Part I and Part II
• SQL -- Views
• JDBC-JSP (these slides use Oracle as example. See instructions on how to connect to SQLServer instead.)
• SQL – Triggers (Chapter from Ullman and Widom’s book. It addresses universal concepts behind trigger mechanisms, using standard SQL syntax. Caution, this material is solely recommended for the concepts. None of the commercial vendors conform to the standard SQL syntax. I have shown in class how MS SQLServer’s syntax differs (check it out here for SQLServer 2008 R2). For any other commercial DBMS, please refer to the vendor’s online documentation. In class, we discussed Example 7.15 and we also provided an alternative trigger using the FOR EACH STATEMENT variation. Check out Example 7.16.

The following reading list refers to the 2002 Edition. Attention: section numbers are different in the 2000 and 2001 Editions.

• Entity Relationship Diagrams: 2.1
• Design Principles: 2.2
• Modeling of Constraints: 2.3
• Translation of E/R diagrams to Relational Designs: 3.2.1-3.2.3
• Representing "isa" in the relational model: 3.3
• Keys and Foreign Keys in SQL: 7.1
• Constraints on the values of attributes: 7.2.1-7.2.2
• ODL: 4.1--4.4
• JDBC: 8.5
• JDBC and JSP programming (class notes)
• Documentation for JDBC
• Documentation for Java Server Pages 2.1 (JSPs)
• Example describing how to use the Delete Trigger to enforce the constraint that there should be atleast 3 faculty members in a thesis commitee
• Constraints and Triggers: 7 (except 7.4.1)

Grading

The project constitutes 80% of the total grade.

The remaining 20% is the final exam.

There is no midterm exam.

[Percentages of individual project milestones (listed on the project page) refer to the project grade.

For instance, Part 1 is worth 15% of the project grade, or equivalently 12% of the overall grade.]