{"id":284,"date":"2016-08-03T10:09:28","date_gmt":"2016-08-03T14:09:28","guid":{"rendered":"http:\/\/folvera.commons.gc.cuny.edu\/?p=284"},"modified":"2021-09-16T14:58:21","modified_gmt":"2021-09-16T18:58:21","slug":"database-administration-fundamentals-sf16sql1001-day-7","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=284","title":{"rendered":"Database Administration Fundamentals (SF16SQL1001) \u2013 Day 7"},"content":{"rendered":"<p>We have covered most of the material of this course except for <a title=\"What is Referential Integrity (RI)? - Definition from Techopedia\" href=\"https:\/\/www.techopedia.com\/definition\/1233\/referential-integrity-ri\" target=\"_blank\" rel=\"noopener\">referential integrity<\/a>.<\/p>\n<blockquote><p><em>Referential integrity is a relational database concept, which states that table relationships must always be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key. Thus, any primary key field changes must be applied to all foreign keys, or not at all. The same restriction also applies to foreign keys in that any updates (but not necessarily deletions) must be propagated to the primary parent key.<\/em><br \/>\n<a title=\"What is Referential Integrity (RI)? - Definition from Techopedia\" href=\"https:\/\/www.techopedia.com\/definition\/1233\/referential-integrity-ri\" target=\"_blank\" rel=\"noopener\">https:\/\/www.techopedia.com\/definition\/1233\/referential-integrity-ri<\/a><\/p><\/blockquote>\n<p>Download the <a title=\"Class Notes for SF16SQL1001 - Day 7 (2016\/08\/01)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/08\/SF16SQL1001_20160801.pdf\">class notes<\/a> for day 7.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have covered most of the material of this course except for referential integrity. Referential integrity is a relational database concept, which states that table relationships must always be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key. Thus, any primary key field [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[7,3,1,17,2],"tags":[],"class_list":["post-284","post","type-post","status-publish","format-standard","hentry","category-sf16sql1001","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=284"}],"version-history":[{"count":2,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/284\/revisions"}],"predecessor-version":[{"id":953,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/284\/revisions\/953"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}