Chapter 10 Relational Integrity

 

What's in a name? that which we call a rose

By any other name would smell as sweet;

 
  --Juliet

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.

Identity

 

I yam ...

Get Simply SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.