DBMS

Keys, ER and normalization

About 9 steps, from the first idea to a mastery test.

Stage 0KeysComing soon
Stage 1Relations and keys2 stepsFree
1. 1Relations and keys14 min
2. 2Relational algebra13 min
Stage 2Modelling the real world2 stepsFree
1. 1Entities, relationships and cardinality13 min
2. 2From ER model to tables13 min
Stage 3Functional dependencies2 stepsFree
1. 1Functional dependencies and closure15 min
2. 2Finding candidate keys14 min
Stage 4Functional dependenciesComing soon
Stage 5Normal forms3 stepsFree
1. 1Anomalies, 1NF, 2NF and 3NF15 min
2. 2BCNF and good decompositions14 min
3. 3When to denormalize12 min
Stage 6Design and masteryComing soon