SQL databases are, or at least should be, built on some pretty strong principles. Although these principles are sometimes relaxed in real life, the database will be more reliable and more efficient if they’re followed as far as possible.
In this chapter, we’re going to look at parts of the existing database and how it can be improved using some of those principles. We’ll look at
-
The basic understanding of normal tables—tables which have been constructed or reconstructed along the core principles
-
Modifying tables ...
