Comp 305-001/488-305: Database Administration

Spring 2016: Tuesdays, 4:15-6:45, Corboy L08

Week 5

Read in Elmasri & Navathe (EN). Chapters are labeled (7th edition)/(6th edition)
Homework 2, due March 1 (two weeks)
    EN6 chapter 5 / EN7 chapter 7:
    exercises 5, 6, 7, 8


Resume with continuation of universal quantification
    employees who works on all the projects controlled by department 4
    departments that are at all locations


Except

Having

Views

Triggers

Postgres schemas, "data dictionary"

ER diagrams