{"id":435,"date":"2022-08-23T16:02:01","date_gmt":"2022-08-23T15:02:01","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=435"},"modified":"2022-08-23T16:02:24","modified_gmt":"2022-08-23T15:02:24","slug":"data-types","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/data-types\/","title":{"rendered":"Data Types"},"content":{"rendered":"<h2 style=\"color: red\">Data Types<\/h2>\n<p><span data-contrast=\"none\">When designing a database, consideration needs to be given to the data type of the field.<\/span><\/p>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"none\">Text<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"none\">Number<\/span><\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"2\"><span data-contrast=\"none\">Date<\/span><\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"2\"><span data-contrast=\"none\">Time<\/span><\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"2\"><span data-contrast=\"none\">Graphics<\/span><\/li>\n<li data-aria-posinset=\"6\" data-aria-level=\"2\"><span data-contrast=\"none\">Calculation<\/span><\/li>\n<li data-aria-posinset=\"7\" data-aria-level=\"2\"><span data-contrast=\"none\">Link<\/span><\/li>\n<li data-aria-posinset=\"8\" data-aria-level=\"2\"><span data-contrast=\"none\">Boolean<\/span><\/li>\n<li data-aria-posinset=\"9\" data-aria-level=\"2\"><span data-contrast=\"none\">Key Field<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"none\">Text<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Used to store letters of the alphabet or a mixture of letters and numbers such as postcode<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Name<\/span><\/b><span data-contrast=\"none\">:\u00a0 Gavin McLeod<\/span><\/p>\n<p><b><span data-contrast=\"none\">Registration<\/span><\/b><span data-contrast=\"none\">:\u00a0 SN62 FHV\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"none\">Mobile<\/span><\/b><span data-contrast=\"none\">:\u00a0 07545661120<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Number<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Integer\u00a0<\/span><span data-contrast=\"none\">\u2013<\/span><span data-contrast=\"none\">\u00a0used to store whole numbers with no decimal point<\/span><\/p>\n<p><span data-contrast=\"none\">Real\u00a0<\/span><span data-contrast=\"none\">\u2013<\/span><span data-contrast=\"none\">\u00a0used to store numbers which could be decimals<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Year Established<\/span><\/b><span data-contrast=\"none\">:\u00a0 2005<\/span><\/p>\n<p><b><span data-contrast=\"none\">Days Absence<\/span><\/b><span data-contrast=\"none\">:\u00a0 4<\/span><\/p>\n<p><b><span data-contrast=\"none\">Weight<\/span><\/b><span data-contrast=\"none\">:\u00a0 12.5<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Date<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Used to store a day, month or year using a variety of formats<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Date of Birth<\/span><\/b><span data-contrast=\"none\">: 31\/05\/2003<\/span><\/p>\n<p><b><span data-contrast=\"none\">Date of Employment<\/span><\/b><span data-contrast=\"none\">: 3 July 2020<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Time<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Used to store hours, minutes and seconds<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Appointment<\/span><\/b><span data-contrast=\"none\">: 16:50<\/span><\/p>\n<p><b><span data-contrast=\"none\">Period<\/span><\/b><span data-contrast=\"none\">\u00a0End:\u00a0<\/span><span data-contrast=\"none\">12:45<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Graphics<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Used to store a different type of data file such as graphics, sound or video<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Club Crest<\/span><\/b><span data-contrast=\"none\">:\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155213\/crest.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-430\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155213\/crest.png\" alt=\"\" width=\"156\" height=\"128\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span class=\"TextRun SCXO65017563 BCX8\" lang=\"EN-GB\" xml:lang=\"EN-GB\" data-contrast=\"none\"><span class=\"NormalTextRun SCXO65017563 BCX8\">Photograp<\/span><\/span><span class=\"TextRun SCXO65017563 BCX8\" lang=\"EN-GB\" xml:lang=\"EN-GB\" data-contrast=\"none\"><span class=\"NormalTextRun SCXO65017563 BCX8\">h<\/span><\/span><span class=\"TextRun SCXO65017563 BCX8\" lang=\"EN-GB\" xml:lang=\"EN-GB\" data-contrast=\"none\"><span class=\"NormalTextRun SCXO65017563 BCX8\">:<\/span><\/span><span class=\"EOP SCXO65017563 BCX8\">\u00a0<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-431\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3.jpeg\" alt=\"\" width=\"177\" height=\"118\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3.jpeg 1260w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3-300x200.jpeg 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3-1024x683.jpeg 1024w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3-768x512.jpeg 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23155342\/GetImage-3-624x416.jpeg 624w\" sizes=\"auto, (max-width: 177px) 100vw, 177px\" \/><\/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\">Calculation<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Calculations can be performed on fields using a formula<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Total Pupils<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A database stores the details of each tutor class in a school. One of the fields is a numeric field called Pupils, which stores the number of pupils in the class. Total Pupils is a calculated field, adding the Pupils field from each record<\/span><\/p>\n<p><b><span data-contrast=\"none\">Average Bill<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A database stores the details of a shopping bills in a supermarket. One of the fields is a numeric field called Total Bill which stores the amount of each bill. Average Bill is a calculated field to determine the average of each bill.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Link<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A web link<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Official Band Home Page<\/span><\/b><span data-contrast=\"none\">:<\/span><span data-contrast=\"none\">\u00a0\u00a0<\/span><a href=\"http:\/\/www.foofighters.com\/\"><span data-contrast=\"auto\">www.foofighters.com<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Contact Page<\/span><\/b><span data-contrast=\"none\">:<\/span><span data-contrast=\"none\">\u00a0\u00a0<\/span><a href=\"http:\/\/www.vodafone.co.uk\/contact-us\"><span data-contrast=\"auto\">www.vodafone.co.uk\/contact-us<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Boolean<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">A Boolean can store one of two values, True or False (or Yes\/No)<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Club Member<\/span><\/b><span data-contrast=\"none\">:\u00a0 True<\/span><\/p>\n<p><b><span data-contrast=\"none\">Driving Licence<\/span><\/b><span data-contrast=\"none\">:\u00a0 False<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b><span data-contrast=\"none\">Key Field<\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Unique field that stores the key for each record<\/span><\/p>\n<p><span data-contrast=\"none\">Examples:<\/span><\/p>\n<p><b><span data-contrast=\"none\">Student ID<\/span><\/b><span data-contrast=\"none\">: 07151102<\/span><\/p>\n<p><b><span data-contrast=\"none\">Product ID<\/span><\/b><span data-contrast=\"none\">: B-1201-FG7315<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Types When designing a database, consideration needs to be given to the data type of the field. Text Number Date Time Graphics Calculation Link Boolean Key Field Text Used to store letters of the alphabet or a mixture of letters and numbers such as postcode Examples: Name:\u00a0 Gavin McLeod Registration:\u00a0 SN62 FHV\u00a0\u00a0\u00a0\u00a0 Mobile:\u00a0 07545661120 [&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-435","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/435","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=435"}],"version-history":[{"count":3,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/435\/revisions"}],"predecessor-version":[{"id":438,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/435\/revisions\/438"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}