Comp 305-001/488-305: Database Administration

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

Week 7

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


Password dataset and indexes

start transaction;
    update employee set salary = salary+500 where lname = 'Borg';
    update employee set salary = salary - 500 where lname =
commit|abort

Note what happens in another window if we look at the data during the transaction.


Dell Store
    final example: average of counts

EER diagrams
    postgres object/relational features