{"id":1354,"date":"2016-12-02T16:40:25","date_gmt":"2016-12-02T21:40:25","guid":{"rendered":"http:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=1354"},"modified":"2017-03-18T18:42:55","modified_gmt":"2017-03-18T23:42:55","slug":"relational-design-tasks-1","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-tasks-1\/","title":{"rendered":"Relational Design Tasks 1"},"content":{"rendered":"<ul>\n<li>Watch videos (90 min) and answer questions from DB8 Relational Design Theory (<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/RD\/SelfPaced\/courseware\/ch-relational_design_theory\/\">https:\/\/class.stanford.edu\/courses\/DB\/RD\/SelfPaced\/courseware\/ch-relational_design_theory\/<\/a>)\n<ul>\n<li>Relational Design Overview (6:18 + 5:38 + 3:23 + 0:49)<\/li>\n<li>Functional Dependencies (7:31 + 3:59 + 12:55 + 1:51 + 1:40)<\/li>\n<li>Boyce-Codd Normal Form (11:51 + 6:35 + 4:38)<\/li>\n<li>Shortcomings of BCNF\/4NF (12:01, with attention to BCNF references n particular)<\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000\">Do Normalization Quiz questions that do NOT involve multivalued dependencies (<\/span>i.e., do questions Q2, Q3, Q4, Q5 from the Normalization Quiz) (https:\/\/class.stanford.edu\/courses\/DB\/RD\/SelfPaced\/courseware\/ch-relational_design_theory\/)<\/li>\n<li>Optionally, read Chapter 3 of U\/W<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Watch videos (90 min) and answer questions from DB8 Relational Design Theory (https:\/\/class.stanford.edu\/courses\/DB\/RD\/SelfPaced\/courseware\/ch-relational_design_theory\/) Relational Design Overview (6:18 + 5:38 + 3:23 + 0:49) Functional Dependencies (7:31 + 3:59 + 12:55 + 1:51 + 1:40) Boyce-Codd Normal Form (11:51 + 6:35 &hellip; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-tasks-1\/\">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-1354","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1354","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=1354"}],"version-history":[{"count":5,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1354\/revisions"}],"predecessor-version":[{"id":1821,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1354\/revisions\/1821"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=1354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}