What You Have Learned

In this chapter, you have been introduced to one of the most important database concepts you will encounter—referential integrity. The four referential integrity constraints discussed in this chapter are restricted deletes, restricted inserts, cascading deletes, and cascading updates. Referential integrity, in addition to field- and rowlevel rules, is a tool that you should employ to ensure the quality of the data within a database. The point that an application is only as good as the database it rests upon has been emphasized multiple times in this book. Taking this point one step further, a database is only as good as the quality of data it stores and the information it can provide. This chapter concludes Part III. To ...

Get Absolute Beginner’s Guide to Databases 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.