{"id":440,"date":"2022-08-23T16:03:48","date_gmt":"2022-08-23T15:03:48","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=440"},"modified":"2022-10-26T13:01:42","modified_gmt":"2022-10-26T12:01:42","slug":"data-dictionary","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/data-dictionary\/","title":{"rendered":"Data Dictionary"},"content":{"rendered":"<p><span data-contrast=\"auto\">A data dictionary is a table that contains all the elements to be present in the database once it is implemented.\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The data dictionary should include:<\/span><\/p>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"auto\">Entity name<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"auto\">Attribute names (fields)<\/span><\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"2\"><span data-contrast=\"auto\">Primary and Foreign keys<\/span><\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"2\"><span data-contrast=\"auto\">Attribute type<\/span><\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"2\"><span data-contrast=\"auto\">Attribute size (text only)<\/span><\/li>\n<li data-aria-posinset=\"6\" data-aria-level=\"2\"><span data-contrast=\"auto\">Required<\/span><\/li>\n<li data-aria-posinset=\"7\" data-aria-level=\"2\"><span data-contrast=\"auto\">Validation<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">\u00a0The data dictionary is the design of how the database and will be set it up.<\/span><\/b><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-433\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary.png\" alt=\"\" width=\"732\" height=\"382\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary.png 1238w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary-300x157.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary-1024x534.png 1024w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary-768x401.png 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155919\/data-dictionary-624x326.png 624w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A data dictionary is a table that contains all the elements to be present in the database once it is implemented.\u00a0 The data dictionary should include: Entity name Attribute names (fields) Primary and Foreign keys Attribute type Attribute size (text only) Required Validation \u00a0The data dictionary is the design of how the database and will [&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-440","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/440","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=440"}],"version-history":[{"count":5,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/440\/revisions"}],"predecessor-version":[{"id":582,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/440\/revisions\/582"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}