{"id":36,"date":"2021-03-12T07:50:03","date_gmt":"2021-03-12T07:50:03","guid":{"rendered":"https:\/\/btecu6.uk\/unit2\/?page_id=36"},"modified":"2021-03-12T07:50:03","modified_gmt":"2021-03-12T07:50:03","slug":"activity-1-database-relationships-screen-print-45-minutes","status":"publish","type":"page","link":"https:\/\/btecu6.uk\/unit2\/index.php\/activity-1-database-relationships-screen-print-45-minutes\/","title":{"rendered":"Activity 1: Database relationships screen print (45 minutes)"},"content":{"rendered":"\n<h5 class=\"wp-block-heading\">Walkthrough<\/h5>\n\n\n\n<p>To complete activity 1, you need to normalise the data and create appropriate relationships between the tables. See videos below to guide if unsure how to do this:<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Customer-Table-Sbe-1.mp4\"><\/video><figcaption>Creating table 1: Customer Table<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Event-Table-Sbe-1.mp4\"><\/video><figcaption>Creating table 2: Events Table<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Seat-Sale-Table-Sbe-1.mp4\"><\/video><figcaption>Creating table 3: Seats Table and creating the relationships<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Final-Words-Sbe-1.mp4\"><\/video><figcaption>Final words for activity 1<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Walkthrough To complete activity 1, you need to normalise the data and create appropriate relationships between the tables. See videos below to guide if unsure how to do this:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/pages\/36"}],"collection":[{"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/comments?post=36"}],"version-history":[{"count":1,"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/pages\/36\/revisions"}],"predecessor-version":[{"id":37,"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/pages\/36\/revisions\/37"}],"wp:attachment":[{"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/media?parent=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}