{"id":1190,"date":"2016-04-15T09:30:32","date_gmt":"2016-04-15T09:30:32","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=1190"},"modified":"2016-04-15T09:31:42","modified_gmt":"2016-04-15T09:31:42","slug":"higher-structures-and-links-database-revision","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/15\/higher-structures-and-links-database-revision\/","title":{"rendered":"Higher &#8211;  Structures and links database (Revision)"},"content":{"rendered":"<p>A database is a collection of data stored in a structured, organised manner.<\/p>\n<h3><strong>Flat file databases<\/strong><\/h3>\n<p>A<strong> flat file<\/strong> database has all data is contained in one <strong>file<\/strong> (a table or entity).<\/p>\n<p>Data is organised into <strong>fields<\/strong> (columns or attributes) and <strong>records<\/strong> (rows or occurrences).<\/p>\n<h3><strong>Field Types<\/strong><\/h3>\n<p>Basic field types include: text, numeric, date, time.<\/p>\n<p>Other field types include:<\/p>\n<ul>\n<li><strong>Object<\/strong> (a container) \u2013 can contain graphic, audio, video, etc.<\/li>\n<li><strong>Link<\/strong> \u2013 contains a hyperlink.<\/li>\n<li><strong>Calculation<\/strong> \u2013 contains a formula to calculate its contents from other data in the record. Automatic calculation of data reduces the chance of human error.\n<ul>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1.png\"><img decoding=\"async\" data-attachment-id=\"1191\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/15\/higher-structures-and-links-database-revision\/hdb1\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1.png\" data-orig-size=\"745,494\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"HDB1\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1-300x199.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=80f7471d3ee407e76f23f2c861a68d53bf946bccf492aafa851ececb64d22b6d\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1.png\" class=\"alignnone size-medium wp-image-1191\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1-300x199.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260829T222525Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=80f7471d3ee407e76f23f2c861a68d53bf946bccf492aafa851ececb64d22b6d\" alt=\"HDB1\" width=\"300\" height=\"199\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1-300x199.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=80f7471d3ee407e76f23f2c861a68d53bf946bccf492aafa851ececb64d22b6d 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1-150x99.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1ff3b88fe11adc60f61ca43d757d2b24642dee103d2b40ebf6b93396345f7635 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB1.png 745w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Boolean<\/strong> \u2013 stores Yes\/No or True\/False.<\/li>\n<li><strong>Summary<\/strong> \u2013 calculates data based on data from multiple records in database. For example, totals up the contents of a particular field across all records.<\/li>\n<\/ul>\n<h3><strong>Relational Databases<\/strong><\/h3>\n<p>Relational databases have two or more files linked together.\u00a0Using linked tables reduces unnecessary duplication of data, therefore reducing the opportunity for error.<\/p>\n<p>Good database design <strong>avoids data duplication<\/strong> by using linked tables where appropriate and <strong>reduces errors in data entry<\/strong> by using suitable validation techniques.<\/p>\n<h3>Relationships<\/h3>\n<p>There are 3 types of relationships between tables in a relational database.<\/p>\n<p><strong>One-to-one (1:1)<\/strong><\/p>\n<ul>\n<li><em>One record in the first table can only link to exactly one record in the second table.<\/em><\/li>\n<li>One-to-one relationships are rarely used, except as a means of splitting up a large, unwieldy table or treating part of a table differently (e.g. keeping some fields secure).<\/li>\n<li><em>Example<\/em>\n<ul>\n<li>In a database with a Customer Details table linked to an Account Details table \u2013 one customer can only have one account, and vice versa.<\/li>\n<li>However, the Customer Details table can be made available to all staff whilst the Account Details table could only be available to senior staff.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>One-to-many (1:M)<\/strong><\/p>\n<ul>\n<li><em>One record in the first table can link to two or more records in the second table.<\/em><\/li>\n<li>Each record in the second table can only be linked to exactly one record in the first table.<\/li>\n<li><em>Example<\/em>\n<ul>\n<li>In a database with a Customers table linked to a Tickets table &#8211; one customer can have many tickets, but each ticket may only have one customer.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Many-to-many (M:M)<\/strong><\/p>\n<ul>\n<li><em>One record in the first table can link to two or more records in the second table.<\/em><\/li>\n<li>One record in the second table can also link to two or more records in the first table.<\/li>\n<li>Many-to-many relationships are usually undesirable in relational database design.<\/li>\n<li><em>Example<\/em>\n<ul>\n<li>In a database with a Pupils table linked to a Teachers table \u2013 one pupil can have many teachers, and vice versa.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Entity Relationship Diagrams<\/strong><\/p>\n<p>Relationships can be represented graphically using an Entity-Relationship (ER) diagram.<\/p>\n<p>There are many different notations for ER diagrams, we will use crow\u2019s foot notation.<br \/>\n\u2022 The names of entities are written in boxes joined by straight lines.<br \/>\n\u2022 At the \u201cmany\u201d end the line forks.<br \/>\n\u2022 At the \u201cone\u201d end the line it judt joins the box.<\/p>\n<p><img decoding=\"async\" data-attachment-id=\"1161\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/09\/higher-design-notations-revision\/erd\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD.png\" data-orig-size=\"580,626\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"ERD\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD-278x300.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f2a4faa125e2b18503dd01c93c8a9bc97ce9fe6a2c3ef8a31b856c60beede369\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD.png\" class=\"alignnone wp-image-1161 size-full\" src=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD.png\" alt=\"ERD\" width=\"580\" height=\"626\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD.png 580w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD-139x150.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=916693b48d18899c5d27de10343541c41ec3de76da4216909c39e7e01cf5dcd5 139w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/ERD-278x300.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f2a4faa125e2b18503dd01c93c8a9bc97ce9fe6a2c3ef8a31b856c60beede369 278w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/p>\n<h3><strong>Keys<\/strong><\/h3>\n<ul>\n<li><strong>Primary Key<\/strong>\n<ul>\n<li>A <strong>primary key<\/strong> is a field which is a unique identifier for each record.<\/li>\n<li>A file may have only one primary key.<\/li>\n<li>At the design stage, primary keys are usually identified by underlining.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Foreign Key<\/strong>\n<ul>\n<li>A <strong>foreign key<\/strong> is the primary key copied from another file, used to link two files.<\/li>\n<li>In order to create a link, the primary key from the \u201cone\u201d entity gets copied into the \u201cmany\u201d entity as a foreign key.<\/li>\n<li>At the design stage, foreign keys are usually identified using an asterisk.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Compound Key<\/strong>\n<ul>\n<li>A <strong>compound key<\/strong> is a key which consists of two or more fields in order to create a unique identifier. This is required when no single field can be used to uniquely identify a record.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Example<\/strong><\/p>\n<pre>Litters\t(Litter ID\r\n\t\tSire\r\n\t\tDame\r\n\t\tNumber in litter\r\n\t\tDOB)\r\n\r\nPuppies\t(Puppy ID\r\n\t\tPuppy name\r\n\t\tSex\r\n\t\tCost of puppy\r\nLitter ID*)\r\n\r\nCustomers\t(Customer name\r\n\t\tAddress\r\nPuppy ID*)\r\n\r\nThere are 3 tables in this database.\r\n\r\n\u2022\tThe Litters table has Litter ID as a primary key.\r\n\u2022\tThe Puppies table has Puppy ID as a primary key.\r\n\u2022\tThe Customers table uses Customer name and Address as a compound key.\r\n\r\n\u2022\tLitter ID is a foreign key in the Puppies table.\r\nThis creates a one-to-many relationship between Litters and Puppies.\r\n\r\n\u2022\tPuppy ID is a foreign key in the Customers table.\r\nThis creates a one-to-many relationship between Puppies and Customers.\r\n<\/pre>\n<h3><strong>Field Validation <\/strong><\/h3>\n<p>Using appropriate validation reduces the chance of error when data is input.<\/p>\n<p>Various validation techniques can be used to ensure data is appropriate:<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Presence check<\/strong> \u2013 ensures field cannot be left empty, good validation for a primary key.<\/li>\n<li><strong>Restricted choice<\/strong> \u2013 the user is presented with a list of options to choose from using a drop-down menu, option buttons or similar. This is often used for the input of data for a foreign key, by automatically generating the list of options from the linked file.<\/li>\n<li><strong>Length check<\/strong> \u2013 ensures an appropriate number of characters is input, e.g. minimum of 8 characters, maximum of 20.<\/li>\n<li><strong>Range check<\/strong> \u2013 used on numeric fields to ensure number is within certain range e.g. between 0 and 100.<\/li>\n<\/ul>\n<h3><strong>Queries<\/strong><\/h3>\n<p>Queries allows the user to find information in a database.<\/p>\n<p>Users may perform simple queries looking at the contents of one field or complex queries looking at the contents of many fields.<\/p>\n<p>When answering exam questions always state what data is being searched for and which field it should be in.<\/p>\n<table>\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"733\"><strong>Examples<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"366\">To find all the male pupils who are over 12<\/td>\n<td width=\"366\">SEARCH for \u201cmale\u201d in the Gender field AND &gt;12 in the Age field<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">To find all the people who live in Edinburgh or Glasgow<\/td>\n<td width=\"366\">SEARCH for \u201cEdinburgh\u201d in the Town field OR \u201cGlasgow\u201d in the Town field<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">To find all the people born in the 1990s<\/td>\n<td width=\"366\">SEARCH for &gt;31\/12\/89 in the DOB field AND &lt;1\/1\/00 in the DOB field<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h3><strong>Sorting <\/strong><\/h3>\n<p>Sorting puts database records in order based on the contents of particular fields.<\/p>\n<ul>\n<li>Ascending order goes from A to Z, smallest number to largest number.<\/li>\n<li>Descending order goes from Z to A, largest number to smallest number.<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"733\"><strong>Examples<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"366\">Put the customers in alphabetical order<\/td>\n<td width=\"366\">SORT on Surname field in Ascending order then the Forename field in Ascending order.<\/td>\n<\/tr>\n<tr>\n<td width=\"366\">Find the tallest person in the database<\/td>\n<td width=\"366\">SORT on Height field in Descending order then look at the first record in the list.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>Reports<\/strong><\/h3>\n<p>Reports allow the presentation of selected data from the database.<\/p>\n<p>The output can be customised in a variety of ways, including displaying only chosen fields and formatting the data in a particular way.<\/p>\n<p>Here is a report which has been produced to show details of all employees who earn more than \u00a330000.<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2.gif\"><img decoding=\"async\" data-attachment-id=\"1195\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/15\/higher-structures-and-links-database-revision\/hdb2\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2.gif\" data-orig-size=\"390,378\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"HDB2\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2-300x291.gif?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5ab63b7df2cad52155b4941ce1baaf03da1841b307f0a425474bfc27acbb54a1\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2.gif\" class=\"alignnone size-medium wp-image-1195\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2-300x291.gif?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260829T222525Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=5ab63b7df2cad52155b4941ce1baaf03da1841b307f0a425474bfc27acbb54a1\" alt=\"HDB2\" width=\"300\" height=\"291\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2-300x291.gif?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5ab63b7df2cad52155b4941ce1baaf03da1841b307f0a425474bfc27acbb54a1 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/HDB2-150x145.gif?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c3b61ed34461ff0f6aa3a39f4d3983f7588defd9daadac3c110c383e258483ce 150w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>The above report has less fields than the full database and also includes a header and summary fields. Changes to the formatting of the Birth Date column and other column headings.<\/p>\n<h3><strong>Forms<\/strong><\/h3>\n<p>Database creators can prepare forms layouts specially designed for inputting data, to help improve usability.<\/p>\n<p>A well laid-out form, using suitable techniques such as drop-down menus or checkboxes, reduces the typing required and makes data input easier and faster.<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31.png\"><img decoding=\"async\" data-attachment-id=\"1196\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/15\/higher-structures-and-links-database-revision\/db3-2\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31.png\" data-orig-size=\"315,185\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"DB3\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31-300x176.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d2a56c7c09290fea2239065fd23a61aef0e7e5c4c35b2e07296e9170abf4ba20\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31.png\" class=\"alignnone size-medium wp-image-1196\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31-300x176.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260829T222525Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=d2a56c7c09290fea2239065fd23a61aef0e7e5c4c35b2e07296e9170abf4ba20\" alt=\"DB3\" width=\"300\" height=\"176\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31-300x176.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d2a56c7c09290fea2239065fd23a61aef0e7e5c4c35b2e07296e9170abf4ba20 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31-150x88.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a7c91e7a302b0cdc798cb340916ec591bd789600f7c7602b685d7bd19b8aa97d 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB31.png 315w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h3><strong>Data dictionaries<\/strong><\/h3>\n<p>A data dictionary is a design notation used to show the fields required in each table of a relational database, including field types, validation required, etc.<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd.png\"><img decoding=\"async\" data-attachment-id=\"1163\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/09\/higher-design-notations-revision\/dd\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd.png\" data-orig-size=\"709,200\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"dd\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd-300x85.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1be79b9905c8d3a61137aaa7e1365cee47766af70a0853b6df3707c145e48207\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd.png\" class=\"alignnone size-medium wp-image-1163\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd-300x85.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260829T222525Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=1be79b9905c8d3a61137aaa7e1365cee47766af70a0853b6df3707c145e48207\" alt=\"dd\" width=\"300\" height=\"85\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd-300x85.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1be79b9905c8d3a61137aaa7e1365cee47766af70a0853b6df3707c145e48207 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd-150x42.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQC%2BCrHUBdHN5HqOm81FpazyQB7ktLPQYZh11GXra9bYjQIgYEqTcexflLZcM5%2F%2BdhG7knA%2Baw1T%2FoVftrJwtE8M%2F2squAUIbxAFGgwyNzM1NzAxOTU0MzMiDFNgo%2FDwdM%2BxldKlkiqVBf40NvQkg1bNCK9EqDaqjGBw2Ix5trN41elznkCn%2FX11rcfA45sS5dZAy04M%2FJWbnVbVVqQAbWdaGBWbOJog0fKV%2FDuHBBSQSoPlbaDWuZRtw12YSFegWpM%2B3h%2BngcV0gIu7tgh8SEwgkHyqoyL%2B787LRKTPKviFGSA3uHQaWLMgjomQk9GW2TKHeMvSDAk12TwsJIiE%2FrJYvDuuwdK09BAYyb5WVPmNXPKMxifq43aS5G2bLbQrvPM56dNzatk87jnxY4EL11yEMSVl55EX2UyE0%2FfkTh2qIqPyQ1KUF%2BlYTajcoB%2FixJ8%2BAkDF0wadWeDxqFqKu7OriLl11untwphn%2F1xOeq6Si0oxe7BSgi%2FZh7aX7lMunZTgUuDx7HPVP3rZXNeoCGx75bHSXt3vfT6Qrt2KlC%2BzkmftVazDLz6Id0yNLLsCkYh4BkPO8195glj9N9oApJYd4vT1B%2FqZXpggYLq9HeSG7xa2o4C0KLHJq2iGemBfKQOOSeITqShY3Q7vzlXz%2BqZQgXSYDUm3BL8ij0SUqxANzSYHGg75sMM4J5oaU9xA%2F0DDdGWFor3Jya2poTV%2BMkOotOKaz7feaASak%2FpNf6az%2BmcgwulQlOvjUP61q%2F3ZWq2oL9Vr1Wy5LHnFxeBmPXVlebBgN7Wpkd%2BwBxBbWw3QyiDXKKWt5k%2FExZmr3IKPFeEUqLHZX%2FuDrZAJ87wXWcoz8xvabYqsMN9Rv4Y54CNoqowWMAh1oiul8jJJ7nZ7514%2FcrkeCBMPDTKsumF30nRCMWrH3zVbcKWY6iJyF60ht0Mq32qf9uOpyMKjpBlZKjIUUDNfMMbhvJINplkh%2FK6fYeJKczAW3FhTWSBSPO7Utbqd%2B3NULTgOFTbJUfcwzK3N1AY6sQHMCQzxEWwcCXsYhDDGTzxKsjg8Nl%2FyKvyzThjh8JfYet8QO5l8J6L%2B%2BflMLwfNXU8Ju4sxYdBmE4qicp7kQBzfGqevsGJ8PdgiM4ukMkagjrNyAEH2qBd3wFfUWjxCW3Mgmw2FCwiq5X%2FSe823bAhjhGfz6N5oFDvZAsav%2FmetxPfsC%2FQMyNkr%2F5sN8XeO0316jtxUK4AXTt73PC2byvYSmcFW5Y2u11DcYy3ueIxSGTc%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZAV5M56W%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T222525Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=3eaf479672db2255cc423988a50b83080bf30580f586226ea555274f076e0399 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/dd.png 709w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><em>Thank you to C O\u2019Toole &amp; A Madill from Braidhurst High School for allowing me to edit and publish this here.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A database is a collection of data stored in a structured, organised manner. Flat file databases A flat file database has all data is contained in one file (a table or entity). Data is organised into fields (columns or attributes) and records (rows or occurrences). Field Types Basic field types include: text, numeric, date, time. &hellip;<\/p>\n","protected":false},"author":32,"featured_media":1078,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17010,319,475,73746],"tags":[],"class_list":["post-1190","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-information-systems-development","category-oldhigher","category-revision","category-structures-and-links-database"],"jetpack_featured_media_url":"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/03\/higher.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/comments?post=1190"}],"version-history":[{"count":6,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1190\/revisions"}],"predecessor-version":[{"id":1199,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1190\/revisions\/1199"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media\/1078"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=1190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=1190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=1190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}