§ Class Slides 16: Database Design (Cont.)

Class Slides 15: Database Design (Cont.)
Home

The following slides continue discussing the database design, normalization.

Slide 16.1: Database anomalies
Slide 16.2: Functional dependencies (FDs)
Slide 16.3: Functional dependencies (FDs) (cont.)
Slide 16.4: Logical implications among functional dependencies
Slide 16.5: Some implications of Armstrong’s Axioms
Slide 16.6: A minimum set of functional dependencies
Slide 16.7: Closure and cover
Slide 16.8: Closure and cover (cont.)
Slide 16.9: Minimum cover
Slide 16.10: Example 6.6.8
Slide 16.11: Lossless decomposition
Slide 16.12: Database schema
Slide 16.13: Normal forms
Slide 16.14: Proposition 6.8.1
Slide 16.15: Proposition 6.8.2

  ☂ References

Slide 16.a: Description of the database normalization basics
Slide 16.b: Database normalization







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