We're sunsetting PodQuest on 2025-07-28. Thank you for your support!
Export Podcast Subscriptions
cover of episode Enforcing Database Relationships Part II

Enforcing Database Relationships Part II

2014/5/23
logo of podcast How to Program with Java Podcast

How to Program with Java Podcast

Shownotes Transcript

In this SQL tutorial episode/post we’re going to learn how to enforce our SQL relationships that we’ve already learned about. We’re going to be tackling the one-to-one and many-to-many relationships and we’re going to learn how to write the code to enforce these relationships in our database.

As outlined in the podcast, we are going to be focusing on the many-to-many relationship with the author and bookexample. Remember that one author can publish many books, and one book can be written by many authors. This indicates a many-to-many relationship and I’m going to show you how to enforce that relationship in your database...

 

Show notes available via http://howtoprogramwithjava.com/session45