{"id":1337,"date":"2016-11-19T22:46:57","date_gmt":"2016-11-20T03:46:57","guid":{"rendered":"http:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=1337"},"modified":"2018-02-01T09:13:04","modified_gmt":"2018-02-01T14:13:04","slug":"constraints-and-triggers-exercises-2","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/constraints-and-triggers-exercises-2\/","title":{"rendered":"Constraints and Triggers Exercises 2"},"content":{"rendered":"<ul>\n<li>Independent work on the Social Network Exercises:\u00a0(<a href=\"https:\/\/lagunita.stanford.edu\/courses\/DB\/Constraints\/SelfPaced\/courseware\/ch-constraints_and_triggers\/\">https:\/\/lagunita.stanford.edu\/courses\/DB\/Constraints\/SelfPaced\/courseware\/ch-constraints_and_triggers\/<\/a>) You can see Doug&#8217;s <a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/SocialNetworkingTriggerExercises.pdf\">visualizations of problem statements<\/a>, but beware &#8212;\u00a0people vary of the ways that they (best) visualize information). But the bigger lesson is that\u00a0drawing can sometimes help.<\/li>\n<\/ul>\n<p>Optional for later:<\/p>\n<ul>\n<li>Do DB11\u00a0<a href=\"https:\/\/class.stanford.edu\/c4x\/DB\/Constraints\/asset\/opt-constraints.html\">EXTRA movie database constraint and referential integrity exercises<\/a><\/li>\n<li>Do DB11\u00a0<a href=\"https:\/\/class.stanford.edu\/c4x\/DB\/Constraints\/asset\/opt-triggers.html\">Extra Social-Media Triggers Exercises<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Independent work on the Social Network Exercises:\u00a0(https:\/\/lagunita.stanford.edu\/courses\/DB\/Constraints\/SelfPaced\/courseware\/ch-constraints_and_triggers\/) You can see Doug&#8217;s visualizations of problem statements, but beware &#8212;\u00a0people vary of the ways that they (best) visualize information). But the bigger lesson is that\u00a0drawing can sometimes help. Optional for later: Do &hellip; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/constraints-and-triggers-exercises-2\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":633,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1337","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/users\/633"}],"replies":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/comments?post=1337"}],"version-history":[{"count":8,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1337\/revisions"}],"predecessor-version":[{"id":2097,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1337\/revisions\/2097"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=1337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}