Databases
📐 Design, normalization and data modification
Design solid relational schemas (PK, FK, 1:1, 1:N and N:M relationships), normalize up to 3NF and modify data with INSERT, UPDATE and DELETE and integrity constraints.
What you'll learn
- Design 1:1, 1:N and N:M relationships with primary keys (
PK) and foreign keys (FK) - Model an N:M relationship through a junction table
- Normalize a schema up to 3NF, removing redundancy and dependencies
- Modify data with
INSERT,UPDATEandDELETEand protect its integrity with constraints (NOT NULL,UNIQUE,CHECK,FOREIGN KEY)
Lessons
Relational design: keys and relationshipsPK, FK and 1:1, 1:N and N:M relationships with a junction table. Normalization: 1NF, 2NF and 3NFRemoving redundancy and anomalies by bringing the schema to normal form. Modifying data: INSERT, UPDATE, DELETE and constraintsDML to write data and constraints to protect it.Practice this module in the app
DevPath is a hands-on course: you read the theory here; in the app you put it into practice with exercises that really run, offline.
Start free in the app →