{"id":703,"date":"2015-03-24T15:25:17","date_gmt":"2015-03-24T15:25:17","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=703"},"modified":"2015-03-24T15:25:54","modified_gmt":"2015-03-24T15:25:54","slug":"structures-and-links-database","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/03\/24\/structures-and-links-database\/","title":{"rendered":"Structures and  links  (database)"},"content":{"rendered":"<ul>\n<li>Database structure: field, record, file<\/li>\n<li>Database structure: flat file, linked tables, primary keys, foreign keys<\/li>\n<li>Field types (text, numbers, date, time, graphic, object, calculated, link, boolean)<\/li>\n<li>Validation (presence check, restricted choice, field length, range)<\/li>\n<li>Database operations search, sort (on multiple fields)<\/li>\n<li>Good design to avoid data duplication and modification errors (insert, delete, update)<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<h2>Database structure<\/h2>\n<ul>\n<li><strong>field<\/strong> &#8211; the fields below; Exhibitor, Company Name, Area, Stand Number, Product Reference, Item Name, Price (\u00a3)<\/li>\n<li><strong>record<\/strong> &#8211; A single row in a table, there are 8 records below<\/li>\n<li><strong>file<\/strong> &#8211; the entire database<\/li>\n<li><strong>flat file<\/strong> all the data is stored in one table<\/li>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"720\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/03\/24\/structures-and-links-database\/attachment\/1\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1.png\" data-orig-size=\"480,220\" 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=\"1\" 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\/2015\/03\/1-300x137.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=eefebde272dc3127d9ad37c2c2112ed80bf7bc6baa3dd5c51af75d2ff96564e5\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1.png\" class=\"alignnone wp-image-720 size-full\" src=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1.png\" alt=\"1\" width=\"480\" height=\"220\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1.png 480w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1-150x68.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f8b37b8b02aa50733fafe7d089c18ccfa702baa186dc481add5932b2a6cd298f 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/1-300x137.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=eefebde272dc3127d9ad37c2c2112ed80bf7bc6baa3dd5c51af75d2ff96564e5 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/a>\n<ul>\n<li>Drawbacks Data duplication Data inconsistency or update\/ deletion\/insertion anomalies Data integrity errors (due to data inconsistency) Inconsistent search results in multi-value fields<\/li>\n<\/ul>\n<\/li>\n<li><strong>linked tables<\/strong>\u00a0data is stored in tables that are linked together.\n<ul>\n<li>The table above would be split into<\/li>\n<li>EXHIBITOR(<span style=\"text-decoration: underline\">Exhibitor Code<\/span>, Company Name, Area) P<\/li>\n<li>RODUCT(<span style=\"text-decoration: underline\">Product Ref<\/span>, Item name, Price (\u00a3), Exhibitor Code*)<\/li>\n<li><span style=\"text-decoration: underline\"><strong>primary keys<\/strong><\/span> &#8211; these are unique identifiers for each row in a table<\/li>\n<li><strong>foreign keys*<\/strong> \u2013 a primary key from a different table<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Database operations<\/h2>\n<ul>\n<li><strong>Simple search<\/strong> \u2013 a search on ABC Music would return the following<\/li>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"721\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/03\/24\/structures-and-links-database\/attachment\/2\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2.png\" data-orig-size=\"480,43\" 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=\"2\" 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\/2015\/03\/2-300x26.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e3c5b192f8b0c3c75b42e83e8309e517da6c0296f1a04593963fb6607ea2a5c6\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2.png\" class=\"alignnone wp-image-721 size-full\" src=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2.png\" alt=\"2\" width=\"480\" height=\"43\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2.png 480w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2-150x13.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ba1e9c4afcdc06203f2bddeeb592aba706b9422be88e556371aec2a58b0d457d 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/2-300x26.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e3c5b192f8b0c3c75b42e83e8309e517da6c0296f1a04593963fb6607ea2a5c6 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/a><\/li>\n<li><strong>Complex search<\/strong> \u2013 Searching on two (or more) fields at once for example\n<ul>\n<li>Company name = FutureTech and Price &gt; 1500 would return the following<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"722\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/03\/24\/structures-and-links-database\/attachment\/3\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3.png\" data-orig-size=\"480,21\" 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=\"3\" 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\/2015\/03\/3-300x13.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=69283f25c87df25af1ac7b870d3f187f67778c26c97e972fa651cf80e6443f30\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3.png\" class=\"alignnone wp-image-722 size-full\" src=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3.png\" alt=\"3\" width=\"480\" height=\"21\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3.png 480w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3-150x6.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f3b6400565b317d37622dccf50a73f6a59c990a321d4ce270c9623286307cba0 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/3-300x13.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=69283f25c87df25af1ac7b870d3f187f67778c26c97e972fa651cf80e6443f30 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/a><\/li>\n<li><strong>Simple sort<\/strong> \u2013 Sorting a table by one field, class registers are sorted by surname\n<ul>\n<li>Allan, Tom<\/li>\n<li>Bennet, Gordon<\/li>\n<li>Clark, Petula<\/li>\n<li>Donaldson, Luke<\/li>\n<li>Elliot, Paula<\/li>\n<\/ul>\n<\/li>\n<li><strong>Complex sort<\/strong> \u2013 same as above but if two people have the same second name they are sorted by first name as well\n<ul>\n<li>Allan, Tom<\/li>\n<li>Bennet, Gordon<\/li>\n<li>Clark, Petula<\/li>\n<li>Donaldson, Luke<\/li>\n<li>Elliot, Paula<\/li>\n<li>Ferguson, Alex<\/li>\n<li>Ferguson, Sarah<\/li>\n<\/ul>\n<\/li>\n<li><em>This is in Alphabetical or Ascending order<\/em><\/li>\n<\/ul>\n<h2>Field types<\/h2>\n<ul>\n<li><strong>text<\/strong> \u2013 A Roberts, ML1 3XF<\/li>\n<li><strong>numbers<\/strong> &#8211; 124<\/li>\n<li><strong>date<\/strong> \u2013 29 April 2012<\/li>\n<li><strong>time<\/strong> \u2013 08:30<\/li>\n<li><strong>object<\/strong> \u2013 Picture, video or sound file.<\/li>\n<li><strong>calculated<\/strong> \u2013 pay * 20%<\/li>\n<li><strong>link<\/strong> \u2013 www.bbc.co.uk<\/li>\n<li><strong>Boolean<\/strong> \u2013 either yes or no<\/li>\n<\/ul>\n<h2>\u00a0Validation<\/h2>\n<ul>\n<li><strong>presence check<\/strong> \u2013 data must be entered before the user can continue, usually has a star.<\/li>\n<li><strong>restricted choice<\/strong> &#8211; please see below, the user can only select one option.<\/li>\n<\/ul>\n<h3 style=\"padding-left: 30px\">Benefits<\/h3>\n<ul>\n<li>Reduces the chance of human error<\/li>\n<li>Does not require the user to type a text response<\/li>\n<li>Speeds up the ordering process as inputs are reduced to mouse clicks<\/li>\n<li>Allows the use of a touchscreen<\/li>\n<\/ul>\n<h2>Design<\/h2>\n<p>Good design to avoid data duplication and modification errors (insert, delete, update)<\/p>\n<p>Flat file databases can lead to errors as shown below<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"723\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/03\/24\/structures-and-links-database\/attachment\/4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4.png\" data-orig-size=\"529,155\" 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=\"4\" 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\/2015\/03\/4-300x87.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=213e027894ae504953208a078cb24cf1f9a9a7718c14be6a50eed92daa211c83\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4.png\" class=\"alignnone wp-image-723 size-full\" src=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4.png\" alt=\"4\" width=\"529\" height=\"155\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4.png 529w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4-150x43.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=50fe940f0f7c05d7b265bf4c3dd80e8f710360a2ce24d73d2f4ce8186508367f 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/03\/4-300x87.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEDQaCWV1LXdlc3QtMSJHMEUCIEW9ei9Tzd7rYzeVob%2BJ8m91qRR5gl6r%2F0%2FiEdyAqodvAiEAzA6I4BTtbmA1qDt8zc4qm4R3zfvXrVDGF7fcAyBcKD0qwQUI%2Ff%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAFGgwyNzM1NzAxOTU0MzMiDKnuqjelEb9Cg7ucfyqVBcPSI4PvGug1Y5pv8DPm%2Fbj4xPHDzdp2uisVPs9IaADINHo%2BsBykt4LeAPwPFtWyKOloXfUiy95YF6BwjN8vgilvQYuFnp12WiNUusfmKGt%2FO0pEyKphtMw%2F9INYwEJl0JJ%2FfIKfMonEUEwQXhTLksRVB1KZbHBPxbmsLhQgUNupfpduEQV6TvgZ%2FCxJYICa3mnns24WrqdwVXoRuyPeYrF3QtYXzCrxv%2BDVvh4emQJAL7snN%2BBf6KqPCh7%2BttqIgwCMKBpiNS0KvPxp%2FEoZKvREKqSQpNPQt3QLBH4sApptQjGKLK8ok2mMfj3vAG8YnK8DRxjq1WKGHirF0wHzBc6oRSqCwJfHc3wYXkZW8819RO%2BzoZXauTK5WQmopP1vPNoC3UJZ1do2YwHMWuZXJF%2FK8%2FUmer0k27I5pZIGi7j%2BH%2BUBUrGcXEvWldOqTVqQF2OvMQLifaYDOQ%2BvLz8%2FIRYUPABV2Wy2l2s2s0HrSnlsQpIbHUAJuDAN9Vo618HRJMz0K9OVBBuygLfAGUNjT6j0gu%2FPDxEzFlkyKRL%2BWCwMDKLVcemzVgc8ONLMVFAYCvpEq3jD4J65LjsvdSMeqgJ9SmgOEAiS%2Fd34sYjd8MRNtsP2QN2TnP7DOsSvmhL6%2Bhg43FYSbM9KKUC122kRirEy0NqoI9tA3BqqMxS%2F8wNhP78cxVY%2FRVu3zknIWDJQNZa7N3aMKnHG6C9neO6RxVQvVJ%2FvbR02vR5X2BfQVqdhy1v0gbqrayeY9Ngln9nzaJczcLtG3ix%2FDPcoxsipzDaheZfwyauN7%2FakGH4jPEtJdBRrGdUunLWFuIjJJEyu0eyS%2BoPQOG9k0nExyjCxAcW%2F0pEWSFbE%2B4wPJ6aWEEGYB%2BhjbmAwpdyB0AY6sQGYuKpEhGsnm4VqP%2FONlPvkRXdKAeQLUflvHeO7gJ80wb9Bv%2FgOHQKYnaMU19hjwnb9O%2FEm2%2B7dQ4znoXWwqRn2gUNRpCne6ph9zjEdu7QAYSemR%2FmDnj2btYcPWpEvne4a1Y3MdfEWxVJm4BEvwoc2kiKySBB0av%2FgMN2URzfNN6LziIzswR1WUKlQOr9RTIx%2BcNeqTUL8ZYlIjLFX2DrJ%2FKUWRF5v9qv%2BHxBhHE%2BCl9U%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UQ3GIJPFZ%2F20260510%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260510T122555Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=213e027894ae504953208a078cb24cf1f9a9a7718c14be6a50eed92daa211c83 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>Is Member Number 1034 a man called John Silver or a woman called Joan Silver?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database structure: field, record, file Database structure: flat file, linked tables, primary keys, foreign keys Field types (text, numbers, date, time, graphic, object, calculated, link, boolean) Validation (presence check, restricted choice, field length, range) Database operations search, sort (on multiple fields) Good design to avoid data duplication and modification errors (insert, delete, update)<\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17010,17013,475],"tags":[455,33639,33642,33640,33641],"class_list":["post-703","post","type-post","status-publish","format-standard","hentry","category-information-systems-development","category-national-5","category-revision","tag-database","tag-flat-file","tag-foreign-keys","tag-linked-tables","tag-primary-keys"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/703","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=703"}],"version-history":[{"count":3,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/703\/revisions"}],"predecessor-version":[{"id":725,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/703\/revisions\/725"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}