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

Database System Applications
CSE132B

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

Class Web Page

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

Schedule

	Mon	Tue	Wed	Thu	Fri
Lecture		11:00am - 12:20 pm WLH 2005		11:00am - 12:20 pm WLH 2005
Discussion	1:00-1:50pm CENTR 115
TA Office Hours	5:00-6:30pm CSE B270A Nikos		5:30-7:00pm CSE B250A Ainur	3-4pm (CSE 3217) Nikos	9:00-10:30am CSE B260A Karthik
Instructor Office Hours			1:00 - 2:00 pm CSE 3238 (and by appointment)

Staff

• Instructor: Alin Deutsch (deutsch at cs dot ucsd dot edu)
• TAs: Nikos Coulouris, Karthik Rajendran and Ainur Smagulova {nkoulour|krajendr|asmagulo} [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 SQLServer 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.]