How do the primary key and foreign key relationships support consistency?

Questions ArchiveCategory: DatabaseHow do the primary key and foreign key relationships support consistency?
Cindi Teasley asked 2 years ago

Apparently, consistency is supported by the primary and foreign key relationships in the tables, but I don’t understand how. I also don’t see how consistency is supported more than accuracy.

1 Answers
Justis answered 2 years ago

I feel like I’m missing some context here, if this doesn’t help feel free to email or come to TA hours. Consistency, as defined in the book, has to do with poor programming or poor database administration. If primary and foreign keys are misaligned or don’t match somehow, you will run into a consistency issue in your database. Each individual table might be fine, but your data will not be consistent across tables. This will become increasingly evident as you start joining tables in queries in that database. Best of luck!

Your Answer

17 + 18 =

css.php