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 ...

Get Simply SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.