{"id":42,"date":"2021-03-12T08:00:08","date_gmt":"2021-03-12T08:00:08","guid":{"rendered":"https:\/\/btecu6.uk\/unit2\/?page_id=42"},"modified":"2021-03-12T08:00:08","modified_gmt":"2021-03-12T08:00:08","slug":"activity-2-table-structures-and-validation-45-minutes","status":"publish","type":"page","link":"https:\/\/btecu6.uk\/unit2\/index.php\/activity-2-table-structures-and-validation-45-minutes\/","title":{"rendered":"Activity 2: Table structures and validation (45 minutes)"},"content":{"rendered":"\n<h5 class=\"wp-block-heading\">Walkthrough<\/h5>\n\n\n\n<p>To complete activity 2, you need to apply validation techniques to your fields. <\/p>\n\n\n\n<p>You MUST also evidence all the validation in the document. Your database will not be marked &#8211; only the documents get marked.<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Validation-Point-1-Presence-Check-1.mp4\"><\/video><figcaption>Validation Point 1 &#8211; Presence Check<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Validation-Point-2-Format-Check-1.mp4\"><\/video><figcaption>Validation Point 2 &#8211; Format Check<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Validation-Point-3-Table-Lookup-1.mp4\"><\/video><figcaption>Validation Point 3 &#8211; Table Lookup<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Validation-Point-4-Table-Lookup-Or-Value-Lookup-1.mp4\"><\/video><figcaption>Validation Point 4 &#8211; Table Lookup Or Value Lookup<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Validation-Point-5-And-6-Range-Check-1.mp4\"><\/video><figcaption>Validation Point 5 And 6 &#8211; Range Check<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Don&#8217;t forget to EVIDENCE your work. Use the guides below:<\/h3>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Activity-2-Evidencing-Tables-1.mp4\"><\/video><figcaption>Activity 2 Evidencing Tables<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Activity-2-Evidencing-A-Presence-Check-1.mp4\"><\/video><figcaption>Activity 2 Evidencing A Presence Check<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Activity-2-Evidencing-A-Length-Check-1.mp4\"><\/video><figcaption>Activity 2 Evidencing A Length Check<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/btecu6.uk\/unit2\/wp-content\/uploads\/2021\/03\/Activity-2-Evidencing-Last-3-Validation-Types-1.mp4\"><\/video><figcaption>Activity 2 Evidencing Last 3 Validation Types<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Walkthrough To complete activity 2, you need to apply validation techniques to your fields. You MUST also evidence all the validation in the document. Your database will not be marked &#8211; only the documents get marked. Don&#8217;t forget to EVIDENCE your work. Use the guides below:<\/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\/42"}],"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=42"}],"version-history":[{"count":1,"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/pages\/42\/revisions"}],"predecessor-version":[{"id":44,"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/pages\/42\/revisions\/44"}],"wp:attachment":[{"href":"https:\/\/btecu6.uk\/unit2\/index.php\/wp-json\/wp\/v2\/media?parent=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}