This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Multiplicity, weak entity sets, ISA relationships Design theory (FDs , MVDs , BCNF, 4NF) Help eliminate redundancy Key, the whole key, nothing but the key Attribute closure, chase SQL NULL and three-value logic nifty feature, big mess Bag versus set semantics SFW (or SPJ) queries, subqueries, grouping and aggregation Modifications Constraints the more you know the better you can do Recursion: fixed-point iteration; stratified recursion OLTP vs. OLAP 3...
View Full Document
This document was uploaded on 01/17/2012.
- Spring '09