The „advanced” part of Andy Pavlo’s great great database course discusses classic database design compromises and the tradeoffs, among other things.

See http://www.cs.cmu.edu/~pavlo/