Database week 6

Comp 305-001/488-305: Database Administration

Spring 2017: Tuesdays, 4:15-6:45, Comm 010

Week 6

February 21

Homework 2: on Sakai, due Mar 1.

Midterm Study Guide is now on Sakai

.
Review single-row nested queries, with timings

Last week we just finished the first example at Not Exists Example

Universal quantification

Group By with HAVING

Views

Triggers

Query trees

ER diagrams:
    other notation
    Invoice and Dellstore
    Ternary relations
    EER diagrams