{"id":452,"date":"2022-08-23T16:31:23","date_gmt":"2022-08-23T15:31:23","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=452"},"modified":"2022-08-23T16:37:07","modified_gmt":"2022-08-23T15:37:07","slug":"validation","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/validation\/","title":{"rendered":"Validation"},"content":{"rendered":"<p><span data-contrast=\"none\">A feature of good database design is validation.<\/span><\/p>\n<p><span data-contrast=\"none\">Validation is a series of checks that can be carried out on the data entered into the fields<\/span><\/p>\n<p><span data-contrast=\"none\">It is good practise to limit fields so that the values they accept :<\/span><\/p>\n<ul style=\"font-weight: 400\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Are sensible<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"none\">Are valid<\/span><\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"none\">Don\u2019t waste storage space<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"none\">Presences Check\u00a0<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A presence check can be used to ensure that data must be entered in a field.<\/span><\/p>\n<p><span data-contrast=\"none\">Makes sure that the field is not left empty<\/span><\/p>\n<p><span data-contrast=\"none\">For example:<\/span><\/p>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"none\">Postcode<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"none\">DOB<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162651\/pressence-check.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-453\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162651\/pressence-check.png\" alt=\"\" width=\"317\" height=\"119\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162651\/pressence-check.png 634w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162651\/pressence-check-300x113.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162651\/pressence-check-624x234.png 624w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Field Length Check<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A field length check can be used to limit the number of characters in a field.<\/span><\/p>\n<p><span data-contrast=\"none\">For example:<\/span><\/p>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"none\">Forename (e.g. maximum 12 characters)<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"none\">Surname (e.g. maximum 15 characters)<\/span><\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"2\"><span data-contrast=\"none\">Postcode (e.g. maximum 8 characters)<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162829\/length-check1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-454\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162829\/length-check1.png\" alt=\"\" width=\"317\" height=\"70\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162829\/length-check1.png 602w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162829\/length-check1-300x66.png 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162910\/length-check.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-455\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162910\/length-check.png\" alt=\"\" width=\"317\" height=\"100\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162910\/length-check.png 620w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23162910\/length-check-300x95.png 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Range Check<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A range check can be used to ensure that data falls between two values.<\/span><\/p>\n<p><span data-contrast=\"none\">For example:<\/span><\/p>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"none\">Enter a date (1 to 31)<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"none\">Enter a rating (0 to 100)<\/span><\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"2\"><span data-contrast=\"none\">Enter the temperature (-50 to 50)<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163034\/range1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-456\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163034\/range1.png\" alt=\"\" width=\"317\" height=\"58\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163034\/range1.png 614w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163034\/range1-300x55.png 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163107\/range-check.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-457\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163107\/range-check.png\" alt=\"\" width=\"317\" height=\"100\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163107\/range-check.png 616w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163107\/range-check-300x94.png 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Restricted Choice\u00a0<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A restricted choice check can be used to limit the user entry to a list of acceptable values.<\/span><\/p>\n<p><span data-contrast=\"none\">For example:<\/span><\/p>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"none\">Day of week (Mon, Tue, Wed, Thu, Fri, Sat, Sun)<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"none\">Driving licence (Full, Provisional, None)<\/span><\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"2\"><span data-contrast=\"none\">Gender (Male, Female)<\/span><\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"2\"><span data-contrast=\"none\">Salutation (Mr, Mrs, Miss, Ms, Master, Lord, Lady, Other)<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163233\/retricted4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-460\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163233\/retricted4.png\" alt=\"\" width=\"317\" height=\"45\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163233\/retricted4.png 630w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163233\/retricted4-300x43.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163233\/retricted4-624x89.png 624w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163455\/restricted.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-461\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163455\/restricted.png\" alt=\"\" width=\"317\" height=\"96\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163455\/restricted.png 626w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163455\/restricted-300x91.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163455\/restricted-624x188.png 624w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163555\/restricted1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-463\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163555\/restricted1.png\" alt=\"\" width=\"489\" height=\"216\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163555\/restricted1.png 710w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163555\/restricted1-300x133.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163555\/restricted1-624x276.png 624w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163556\/restricted2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-464\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163556\/restricted2.png\" alt=\"\" width=\"499\" height=\"258\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163556\/restricted2.png 572w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163556\/restricted2-300x155.png 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/a><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163553\/resticted3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-462\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163553\/resticted3.png\" alt=\"\" width=\"314\" height=\"458\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163553\/resticted3.png 516w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23163553\/resticted3-206x300.png 206w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A feature of good database design is validation. Validation is a series of checks that can be carried out on the data entered into the fields It is good practise to limit fields so that the values they accept : Are sensible Are valid Don\u2019t waste storage space Presences Check\u00a0 A presence check can be [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-452","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=452"}],"version-history":[{"count":3,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/452\/revisions"}],"predecessor-version":[{"id":465,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/452\/revisions\/465"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}