My Notes – DB

Normalizing Your Database

• A table should store only data for a single type of entity.
• A table should avoid nullable columns.
=========

what is normalization? Basically, it’s the process of efficiently organizing data in a database.
There are two goals of the normalization process: eliminate redundant data (for example, storing the same data in more than one table) and ensure data dependencies make sense (only storing related data in a table).

______
CAPital