Database Normalization
Database normalization is the process of organizing tables and columns in a relational database to reduce data redundancy and prevent update, insert, and delete anomalies, typically by following a series of progressively stricter "normal forms."
11 resources across 3 libraries
Glossary Terms(7)
ActiveRecord
Active Record is the Object-Relational Mapping (ORM) layer built into Ruby on Rails that implements the Active Record design pattern, where each model class bo…
Database Normalization
Database normalization is the process of organizing tables and columns in a relational database to reduce data redundancy and prevent update, insert, and delet…
ACID Properties
ACID is an acronym describing four guarantees — Atomicity, Consistency, Isolation, and Durability — that traditional relational database transactions provide t…
Database Indexing
Database indexing is the technique of creating auxiliary data structures — most commonly B-trees or hash tables — that let a database engine locate rows matchi…
Query Optimization
Query optimization is the process of improving how a database query is written and executed so it returns correct results using the least amount of time, memor…
OLTP
OLTP (Online Transaction Processing) refers to database systems and workloads optimized for large numbers of short, concurrent read/write transactions, such as…
Snowflake Schema
A snowflake schema is a dimensional data modeling technique that normalizes dimension tables of a star schema into multiple related sub-tables, reducing data r…
Cheat Sheets(1)
Interview Questions(3)
What is Normalization in Database?
Normalization is the process of organizing data in a database to reduce redundancy, avoid anomalies, and improve data integrity.
What Are 1NF, 2NF, and 3NF in Schema Design?
1NF, 2NF, and 3NF are progressive normalization rules that remove repeating groups, partial key dependencies, and transitive dependencies from a table, each le…
What is Boyce-Codd Normal Form (BCNF)?
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF requiring that for every non-trivial functional dependency X to Y in a table, X must be a superkey —…