{"id":1183,"date":"2016-04-13T09:38:19","date_gmt":"2016-04-13T09:38:19","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=1183"},"modified":"2016-04-13T09:38:19","modified_gmt":"2016-04-13T09:38:19","slug":"national-5-structures-and-links-database-revision","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/13\/national-5-structures-and-links-database-revision\/","title":{"rendered":"National 5 &#8211; Structures and links  database (Revision)"},"content":{"rendered":"<h3>Database structure:<\/h3>\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<\/ul>\n<h3>Flat file database<\/h3>\n<ul>\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\/2016\/04\/DB1.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1184\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/13\/national-5-structures-and-links-database-revision\/db1\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB1.png\" data-orig-size=\"588,269\" 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=\"DB1\" 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\/DB1-300x137.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9bb27073a6d2a14755ba75542e82be651806ca8af010501268530aa1dc52e9a1\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB1.png\" class=\"alignnone size-medium wp-image-1184\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB1-300x137.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260424T103150Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=a75b676413341f1dd9771fb7b6b90bf4492bbc6aa923b39184893d2e78bac5aa\" alt=\"DB1\" width=\"300\" height=\"137\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB1-300x137.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9bb27073a6d2a14755ba75542e82be651806ca8af010501268530aa1dc52e9a1 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB1-150x69.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f76bc178b697eeeee76a0aaae8873cc8b9916413bfa44250cbd10443b1da3d20 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB1.png 588w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li><strong>Drawbacks<\/strong> 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<li>Flat file databases can lead to errors as shown below\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1188\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/13\/national-5-structures-and-links-database-revision\/db4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4.png\" data-orig-size=\"969,284\" 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=\"DB4\" 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\/DB4-300x88.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103150Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=24248f1f3e01cf7774593cdfaf221e1235c45a247f0966dae8a082371f1c20e0\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4.png\" class=\"alignnone size-medium wp-image-1188\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4-300x88.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260424T103150Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=24248f1f3e01cf7774593cdfaf221e1235c45a247f0966dae8a082371f1c20e0\" alt=\"DB4\" width=\"300\" height=\"88\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4-300x88.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8d4b8920792baf4a34f8623ab41ec70eb6ce0b7334d13bc355531ed63f54724b 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4-150x44.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5651cfefc1a57bf09e850196f30359241d3e1aba70e22593c42df60c7a6d5b34 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB4.png 969w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Is it a man John Silver or a woman Joan Silver for member 1034?<\/li>\n<\/ul>\n<h3><strong>Linked tables<\/strong><\/h3>\n<ul>\n<li>Table would be split into\n<ul>\n<li>EXHIBITOR(Exhibitor Code, Company Name, Area)<\/li>\n<li>PRODUCT(Product Ref, Item name, Price (\u00a3), Exhibitor Code*)<\/li>\n<\/ul>\n<\/li>\n<li><strong>primary keys<\/strong> &#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<p>Database operations<\/p>\n<ul>\n<li><strong>Simple search<\/strong> \u2013 a search on ABC Music would return the following\n<ul>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/files\/2016\/04\/DB2.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1185\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/13\/national-5-structures-and-links-database-revision\/db2\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB2-e1460539699833.png\" data-orig-size=\"588,57\" 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=\"DB2\" 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\/DB2-e1460539699833-300x29.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103150Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6acdebe3bebb0e94585821698e3b6d8747a2a9abf222a62d51768cbca856e89e\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB2-e1460539699833.png\" class=\"alignnone wp-image-1185 size-medium\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB2-e1460539699833-300x29.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260424T103150Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=6acdebe3bebb0e94585821698e3b6d8747a2a9abf222a62d51768cbca856e89e\" alt=\"DB2\" width=\"300\" height=\"29\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB2-e1460539699833-300x29.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9059568816ce945df4eb1be9309a272c3e0e424524405f896505691c1cc9a358 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB2-e1460539699833-150x15.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=7f1d3137578ac5722014d4d9d80a55680cd70eced4bc6afdf7e96dc6c98123bc 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB2-e1460539699833.png 588w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Complex search<\/strong> \u2013 Searching on two (or more) fields at once for example <em>Company name = FutureTech and Price &gt; 1500<\/em> would return the following\n<ul>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1186\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/13\/national-5-structures-and-links-database-revision\/db2-2\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755.png\" data-orig-size=\"588,35\" 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=\"DB2\" 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\/DB21-e1460539762755-300x18.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103150Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a1490119e8c03ceb6f58abb6816809a8d85ccc7d86a1891fe69ddee6ca8dc214\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755.png\" class=\"alignnone size-medium wp-image-1186\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755-300x18.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260424T103150Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=a1490119e8c03ceb6f58abb6816809a8d85ccc7d86a1891fe69ddee6ca8dc214\" alt=\"DB2\" width=\"300\" height=\"18\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755-300x18.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=cf9059d8b6f871498ac0015c0f5454907fb65de1e9f9a88e52208ae8878ff039 300w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755-150x9.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=376c1943e34df99e657b9d5aeef39b0394c062908cf9a75981ee3a3a250b9c4e 150w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB21-e1460539762755.png 588w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ul>\n<\/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>This is in an\u00a0Ascending order<\/li>\n<\/ul>\n<h3>Field types<\/h3>\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<h3>Validation<\/h3>\n<ul>\n<li><strong>presence check<\/strong> \u2013 data must be entered before the user can continue, primary and foreign keys are normally required.<\/li>\n<li><strong>restricted choice<\/strong> &#8211; please see below, the user can only select one option.\n<ul>\n<li><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1187\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/04\/13\/national-5-structures-and-links-database-revision\/db3\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3.png\" data-orig-size=\"203,125\" 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:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3.png\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3.png\" class=\"alignnone size-full wp-image-1187\" src=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3.png\" alt=\"DB3\" width=\"203\" height=\"125\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3.png 203w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/04\/DB3-150x92.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIHAiOz%2BTa1pePApyV8JRhZ14uXw8Tv%2Fb2gqRNMMdvb7UAiEAtL3op2oKnvSUGC0j3mh5EbWcKr6O0ZaTSterNNsNZlAquQUIexAFGgwyNzM1NzAxOTU0MzMiDN8wGiW1gHWmsm2K2SqWBTi96Em7CHvDK60YeyIFeY9xhxK9GZMzpuv4MbOfJDoP%2FYH7BREtT8m96cto0mbhglxDl7DvA1u0xe36dI2CkQK9%2BnI9uVKxJHirzn%2BkzdH9MEzL8WB3yEhc2Jx76CtRfxsiZwG2tPPIIfq5r8aod%2FYKw2HdqWlsYv7Zu37ZLKzaVlJbPjYbLJkiijqwFmXonOebA2Q4%2FZsUGhE8BtcVBkE0Kyx8a4I3KPuCmMnOB%2Fw2zeE1N9Kw2%2BZQe4katDBQAB6Q4TBYNEXqBGxtgS4bTyUjwO%2FaBp4tS7jemKiS1aoieNBHwkBuITauVyFUGHuwO7by7IUu9DmCKc2ZdP0Zda9ScB3a0vhWbNgUOoUcPwHydg6LD01fXUMys0n70lKw2htuSVhsyMlTjXeUEM4Z%2FnohsTqQsfC3T6JrQw7XTRBw5CcKjZmsdv1BpptRbnc8dHrVO429LztPIHiXpjD%2Flj580ywnBSGsMAK36EtksqJA1V0QT3qFHEZJ28wPMiBmcPlSvHgZFutEi0nUCVrYBjnn8MC9xcztMqjAF6W9zUtQgIcUqlRXK0uz2uV%2BCBg4qNhksDGeoovVrnHC4T8vabotQu71Goh8RAHbJp8aOY4f1R6v%2Fz1zBBZ2Lxu0kE7KIdZCb8zk3YWtE0jWuWlpMEbbsU56gT0r7DjzNjZC%2FlEDKL8IqK9lbOGrygc2UKL6gFtwSc0QfURr8wRPLhtp4rCL659G1LTvQEDJQfyt7HORtN5niexpQ%2B4fqhZGt2dtec48j5RjVMwvXOtTPAAcyNAVfBERsfGUZgNkUCDwg70N%2BMV2jcofBWCX5hU4ONAdToYeUm4TBgU4H8TmxbAuGTgS2pxqUCUbt4HpugwpxIy3KZpZ4GeHMJf%2FrM8GOrEBwdPnmYdlWt5cY0NFr7CiZwr9qHQherchAVrwYaR924o3vsBP3zfpY3GIiWQrVWwtd%2BWjgxzs50rs8dNwDCk%2Byq8igC%2Fz3HsVdyUGKp6pa%2FMzFy1bgOcgFVRBr%2FJ21wDZWruwYRXZGES0BqRWWohDvHL%2BLqj0ElqWTVOLW3oHF7Wt%2B%2FRELboru2%2BzWuvWX7T4ROFVp%2B3o%2FIjXnqQcHgsIoR%2FdH7WJeECUWzbmdL3jJIyM&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU5EEADAD%2F20260424%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260424T103151Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f896cb5036f6165e8738684e520c0457f3c9ccf84dd42e56a123fe6f30f041c5 150w\" sizes=\"auto, (max-width: 203px) 100vw, 203px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Benefits<\/strong>\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<li>Good design to avoid data duplication and modification errors (insert, delete, update)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database structure: field &#8211; the fields below; Exhibitor, Company Name, Area, Stand Number, Product Reference, Item Name, Price (\u00a3) record &#8211; A single row in a table, there are 8 records below file &#8211; the entire database Flat file database flat file all the data is stored in one table Drawbacks Data duplication Data inconsistency &hellip;<\/p>\n","protected":false},"author":32,"featured_media":1077,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17010,17013,475,73746],"tags":[],"class_list":["post-1183","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-information-systems-development","category-national-5","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\/Nat5.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1183","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=1183"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1183\/revisions"}],"predecessor-version":[{"id":1189,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1183\/revisions\/1189"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media\/1077"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=1183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=1183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=1183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}