The course presents the basic concepts of database systems, emphasizing the relational model. Several major issues of relational database theory are covered: relational queries (algebra and calculus), query processing, data dependencies and their use in schema design and query optimization, basic concurrency control. More advanced topics are covered as time allows and include object-oriented databases and data on the Web. Students become familiar with at least one commercial database system.

When and Where: 5:30pm - 6:50pm, APM 4882

---

Instructor: Victor Vianu

Email: vianu@cs.ucsd.edu
Phone: 858-534-6227
Office hours: Tu, Th 4-5pm, APM 4121, and by appointment

Course policies

---

Syllabus (postcript)

---

Transparencies

---

INGRES SQL assignment, due October 12 (postcript)
Solutions to SQL assignment (postcript)

---

INGRES SQL tips (text)
Data for assignment(text)
Information about the turnin program

---

Practice problems on queries (postcript)
Solutions to practice problems (postcript)

---

Second set of practice problems (postcript)
Solutions (postcript)

---

O2 assignment due at midnight on Monday, November 27
O2tutorial
O2 data
OQL tutorial
O2 discussion session slides

---

Survey paper on rule-based languages (postcript)

---