● videoCS Theory
Database Normalization
Unlock CS Fundamentals on Video
6+ hours across 72 lessons — Data Structures, Algorithms, Cryptography, Binary, Software Design, and Essential Unix Skills.
SECTION
CS Theory
NEXT UP
Review: Big-O Notation
COURSE
Computer Science Fundamentals
34 lessons
About this lesson
There is an established way to design a transactional database: following the rules of normalization. This is the process of essentially turning a single, large spreadsheet into a set of related tables.
Transactional systems can back our applications, but analytical systems power decision making. Data warehouses and data marts store the data and OLAP systems provide the analysis infrastructure.
Unlock CS Fundamentals on Video
6+ hours across 72 lessons — Data Structures, Algorithms, Cryptography, Binary, Software Design, and Essential Unix Skills.