Home
Piazza
Schedule
Staff
Prerequisites
Text and Syllabus
Project
Reading List
Course Policies

Database System Applications
CSE132B

Class Web Page

Lecture notes, problems sets and many announcements will be available on this site.

Schedule

	Mon	Tue	Wed	Thu	Fri
Lecture	3:00 - 3:50 pm WLH 2270		3:00 - 3:50 pm WLH 2270		3:00 - 3:50 pm WLH 2270
Discussion				8:00-8:50pm WLH 2270
TA Office Hours		8:00-9:00am CSE B275 Jayanth	10:00-11:00am CSE B250A Saurabh		8:30-9:30am CSE B260A Shibani
Instructor Office Hours	10:00 - 11:00 am CSE 3238

Staff

• Instructor: Alin Deutsch (deutsch at cs dot ucsd dot edu)
• TA: Saurabh Goyal, s2goyal[at] eng [dot] ucsd [dot] edu
• TA: Jayanth Kalyanasundaram, jakalyan[at] eng [dot] ucsd [dot] edu
• TA: Shibani Subbareddy, ssubbare [at] eng [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 (ODMG standard)
  
• Schema Design and Normal Forms See also slides on the use of functional dependencies in query optimization (not covered in this course, posted just in case you are interested!). This material refers to the Query By Example formalism for query representation, see slides here and a book chapter here.
• SQL -- Data Definition Language (Includes Integrity Constraints)
  
• SQL -- Update Language
• SQL -- Query Language Part I and Part II. See answers to in-class exercises here
• SQL -- Views
• JDBC-JSP (these slides use Oracle as example. See instructions on how to connect to postgres instead.)
• SQL Triggers (See Chapter from Ullman and Widom 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, please refer to the vendor's online documentation. In class, we discuss 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(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 20% of the project grade, or equivalently 16% of the overall grade.]