Database mnemonics

Question

I'm looking for mnemonics to help me with databases, the relational model and transaction theory. For example I learned "ACID" to help me remember the properties of a transaction: atomicity, consistency, isolation, and durability. What others are out there?

score 2 · Answer 1 · answered Feb 10 '10 at 20:40

2

CRUD - Create/Read/Update/Delete, the four basic DB operations.

answered Feb 10 '10 at 20:40

tvanfosson

524,688
99
697
795

score 2 · Answer 2 · answered Feb 10 '10 at 20:55

2

To remember the first three normal forms:

The key, the whole key, and nothing but the key.

answered Feb 10 '10 at 20:55

score 0 · Answer 3 · answered Feb 10 '10 at 22:52

0

Just for giggles:

I'll curse you, if you use a cursor

answered Feb 10 '10 at 22:52

HLGEM

94,695
15
113
186

Depends on how the cursor is used. Not all cursors are bad. There's this rad one from pre-2000 Windows called Dinosaur... – glasnt Feb 10 '10 at 22:54

Database mnemonics

3 Answers3