Data Modelling & Design
Design the database before you type it: entities, cardinality, EERD, the mapping rules, normal forms up to BCNF, and the anti patterns that sink real systems. Built around a drag and drop relation builder.
Every lesson runs real code in your browser, checked the moment you submit. No installing anything, no setup, no waiting.
Start Data Modelling & Design freeWhat this course covers
- Why Modelling Comes Before Typing
- Entities, Attributes and the ER Model
- Relationships and Cardinality
- Weak Entities and Identifying Relationships
- EERD: Generalization, Specialization and Inheritance
- From ERD to Tables: The Mapping Rules
- Resolving Many to Many with a Join Table
- Functional Dependencies
- First Normal Form
- Second Normal Form
- Third Normal Form and BCNF
- When to Denormalize, and What It Costs
- Composite, Surrogate and Natural Keys in Practice
- Referential Integrity and Cascade Rules
- Anti Patterns: EAV, God Tables and Stringly Typed Data
- Capstone: Model a Business from a Written Brief
Other courses
Learn to think like a problem-solver before you write a single line of code. Break big …
Your first Python course, no experience needed. Learn variables, loops, functions, and …
Level up your Python with comprehensions, lambdas, error handling, files, modules, and …
Master OOP in Python: classes, objects, inheritance, polymorphism, encapsulation, abstr…
Go deeper in Python: decorators, generators, type hints, regex, JSON, SQLite, testing, …
Core CS: arrays, lists, stacks, queues, hash tables, trees, graphs, sorting, searching,…
Build your own 2D games from scratch: the game loop, sprites, movement, collisions, and…
Learn Java from zero, with no programming background needed. Write your first program, …
Learn C++ from zero, with no programming background needed. Start with your first progr…
Learn C from zero, with no programming background needed. The language that Unix, Linux…
Learn JavaScript from scratch: variables, types, loops, functions, arrays and objects, …
Build for the browser: structure pages with HTML, style them with CSS, then use live AP…