Database Systems
Syllabus Unit: Operating Systems & Databases
Why it matters
Chapter overview
Explore the physical forces, chemical structures, and thermodynamic equations behind Database Systems. An interactive laboratory simulator mapping variables to physical reactions.
1Relational Model & Normalization
The law, the derivation, and the variable intuition behind Relational Model & Normalization.
Learning Objectives
- State the governing law or principle behind Relational Model & Normalization.
- Rebuild the key formula for Relational Model & Normalization from first principles.
- Predict the outcome of Relational Model & Normalization when one variable doubles or flips.
- Solve one Database Systems numerical on Relational Model & Normalization in SI units.
Key Terms
**Relational Model & Normalization** sits inside *Database Systems* (Operating Systems & Databases in GATE Computer Science & IT Engineering Syllabus). Every physics chapter rests on a law or principle — state that law cleanly first and the formulas that follow become consequences, not facts to memorise.
The governing law
Relational Model & Normalization describes how a physical system responds when its inputs change. The law tells you which quantities are conserved and which are transformed, and — just as importantly — where the law stops holding.
- The conserved quantities involved (energy, momentum, charge).
- The cause-effect relation at the centre of Relational Model & Normalization.
- The special cases: low speed, small angles, ideal conditions.
- The limits where the approximation breaks down.
Systematic derivation
Learn Relational Model & Normalization by rebuilding it — derive, don't memorise:
- Start from the fundamental law of the topic.
- Draw the free-body or system diagram.
- Apply the law along each relevant direction.
- Simplify algebraically to the final relation.
Variable thinking
Mentally run the simulation before reading the options — what happens if you double the temperature or flip the field direction? Predicting the trend of Relational Model & Normalization first catches most wrong choices instantly.
- Temperature up → kinetic energy and velocity up.
- Force applied → acceleration or deflection changes.
- Resistance or friction → energy drains from the system.
- Field direction flipped → the effect reverses sign.