3 ms·
One interview problem I've had before that was clearly intended to measure good database design sense and understanding of normalization was "How would you desi
by CydeWeys 11y ago
One interview problem I've had before that was clearly intended to measure good database design sense and understanding of normalization was "How would you design the database for a restaurant reservation system?" There are a bunch of restaurants, each of which has a bunch of different tables, each of which can be reserved for chunks of time on various days. I won't go into the details, but you can see how a good answer is maximally normalized.
Is normalization taught in a typical CS education outside of a Databases class? Is it a general topic, or is it so specific to the scope of RDBMSs that you don't see it mentioned elsewhere? I don't remember.