3 ms·
To really teach the relational model would take quite some more time. I would discuss database normalization (3NF/4NF/BCNF), query optimization, indexes, foreig
by edejong 12y ago
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.