Database

When one field can’t uniquely identify data, we combine multiple fields to make a unique identity.

Normalization simply means: 👉 “Store each piece of information only once, and connect it properly instead of repeating it everywhere.”

It is a link between two tables that makes sure data in one table matches valid data in another table.

It “collects similar data together” and then calculates results for each group.

It “filters groups after calculation.”

It “helps database find data faster.”

Shows only the rows where both tables have matching values.

It “keeps everything from left side, matches from right if available.”

It “cuts down results to a fixed number.”

It “arranges data in order.”

A primary key is a unique ID for each row in a table.

It “keeps everything from right side, matches from left if available.”

It “chooses rows that match a condition.”