The following slides continue discussing the database design, normalization.
 Slide 16.ⓐ: Description of the database normalization basics (reference)
Slide 16.ⓑ: Database Normalization (reference)
Slide 16.1: Normalization: preliminaries
Slide 16.2: Database normalization
Slide 16.3: A normalization example
Slide 16.4: A normalization example (cont.)—1NF
Slide 16.5: A normalization example (cont.)—FDs
Slide 16.6: A normalization example (cont.)—2NF
Slide 16.7: A normalization example (cont.)—3NF
Slide 16.8: A normalization example (cont.)—BCNF / 3.5NF
Slide 16.9: A normalization example (cont.)—BCNF (cont.)
Slide 16.10: A normalization example (cont.)—4NF
Slide 16.11: A normalization example (cont.)—4NF (cont.)
Slide 16.12: A normalization example (cont.)—5NF
Slide 16.13: A normalization example (cont.)—5NF (cont.)
Slide 16.14: Database anomalies
Slide 16.15: Functional dependencies (FDs)
Slide 16.16: Functional dependencies (FDs) (cont.)
Slide 16.17: Logical implications among functional dependencies
Slide 16.18: Some implications of Armstrong’s Axioms
Slide 16.19: A minimum set of functional dependencies
Slide 16.20: Closure and cover
Slide 16.21: Closure and cover (cont.)
Slide 16.22: Minimum cover
|
|
|
|
