The following slides introduce the relational model and algebra.

Slide 12.1: The relational model
Slide 12.2: The CAP database
Slide 12.3: Database terminologies
Slide 12.4: Database terminologies (cont.)
Slide 12.5: Database terminologies (cont.)
Slide 12.6: The relational rules
Slide 12.7: The relational rules (cont.)
Slide 12.8: Table key
Slide 12.9: Table key (cont.)
Slide 12.10: Table key (cont.)
Slide 12.11: Relational algebra ⇐ next class starting at
Slide 12.12: Set theoretic operations
Slide 12.13: Assignment and alias
Slide 12.14: Product
Slide 12.15: Native relational operations
Slide 12.16: Selection
Slide 12.17: Selection (cont.)
Slide 12.18: Selection (cont.)
Slide 12.19: Precedence of relational operations
Slide 12.20: Join
Slide 12.21: Join (cont.)
Slide 12.22: Division

  ☂ References

Slide 12.a: Relational model in DBMS
Slide 12.b: Introduction of relational algebra in DBMS







      Two dragons walk into a bar.    
      The first one says: It sure is hot in here.    
      His friend snaps back: Shut your mouth!