Re:A Tiny Intro to Database Systems
by edejong on Saturday April 25, 2015 @06:06AM
(#9437859)
To really teach the relational model would take quite some more time. I would discuss database normalization (3NF/4NF/BCNF), query optimization, indexes, foreign key constraints and bridge set-theory with the relational model. Optional parts would be triggers and other kind of constraints.
To understand the query planner is tantamount to making good schema's and requires insight in the underlying data-structures (B-tree) and join methods.
Then, for the student to get used to this way of thinking, I'd have them implement a simple project, e.g. a hotel-booking system.
To understand the query planner is tantamount to making good schema's and requires insight in the underlying data-structures (B-tree) and join methods.
Then, for the student to get used to this way of thinking, I'd have them implement a simple project, e.g. a hotel-booking system.