Students must have taken CSE132A or an equivalent one. CSE132A material will be quickly reviewed (see below).

The course textbook is "A First Course in Database Systems" by Ullman and Widom. We will cover the following material in the order shown below. Items in Italics will be quickly reviewed. The students must have already covered them in CSE132A or an equivalent course.

• Database Modeling: 2.1, 2.2, 2.3-2.5
• The Relational Data Model: 3.1, 3.2, 3.3.1, 3.3.2, 3.4, 3.5-3.8, 3.9
• The Database Language SQL: 5.1-5.8, 5.9, 5.10
• System Aspects of SQL: the full Chapter 7
• Constraints and Triggers in SQL: 6.1, 6.2, 6.3-6.6
• (if time permits) Object-Oriented Query Languages: 8.1-8.7

Note that the textbook of CSE132A, "Database System Concepts" by Korth and Silberschatz, does not cover the material of chapters 6, 7, and 8 at the level required for this course. (The same applies to parts of 2.) Though some books will be put on reserve it is strongly recommended that you obtain the textbook.

The class will involve a "large" multi-step project in designing, querying, and updating a database. The project will be built on IBM's DB2. It will constitute 60% of the grade. You are allowed to work in teams of two. A first cut of the project appears here.

The other 40% of the grade will be based on the final exam. Note that the final will emphasize material that has not been sufficiently exercised by the project.

This is the first time this course is given. Please do not hesitate to provide me with comments on what you like, what you hate, what seems irrelevant, and what is a big unjustified pain!