Teaching Demonstration

Database Systems, , 2022

This is a part of the Normalization topic. These lectures assume students know how to create Entity-Relationship Diagrams (ERDs) from the requirements and how to map the ERD to relational schema.

1- Informal design guidelines
2- Functional dependencies
3- Armstrong axioms and verifying the super keys and candidation keys.
4- Closure
5- 1st normal form