Chapter 10 Relational Integrity
What's in a name? that which we call a rose
By any other name would smell as sweet;
In the previous chapter, we saw the various data types that can be used when defining table columns in our database. Most of the concepts there are simple and straightforward, and should’ve been familiar if you’ve had any exposure to programming at all.
By contrast, this chapter will introduce some topics that are the source of much befuddlement for many people new to databases. This chapter is about relational integrity, the real heart and soul of effective database design. We’ll start our journey into relational integrity with a simple notion—the concept of identity.
I yam ...