Hi there!
You can find out here of “Introduction into Relational Databases” course with theme “Relational Design”.
Themes are below.
- Data Redundancy
- Basic data anomalies
- Principle of full normalization (PoFN)
- 1 NF
- Functional dependency
- Armstrong Axioms
- Axiom of reflexivity
- Axiom of augmentation
- Axiom of transitivity
- Rule of decomposition
- Rule of composition
- Rule of union (notation)
- Rule of pseudo transitivity
- Rule of self determination
- Trivial functional dependency
- Nontrivial functional dependency
- Completely nontrivial functional dependency
- Algorithm of closure
- Projection of functional dependency
- Super Key
- Candidate Key
- 2 NF
- 3 NF
- BCNF (Boyce-Codd NF)
- Hez’s theorem
- Dependency-preserving decomposing
- Multivalued dependency
- Rule of complementation
- Rule of replication
- Rule of coalescence
- Multivalued dependency
- Fagin theorem
- 4 NF
- 5 NF (Projection-Join NF)
- Join dependency
- Principle of orthogonal design (PoOD)
Please if you have some comments / questions or remarks , just let me know about it.
Thanks!