{"id":953,"date":"2015-11-17T13:47:02","date_gmt":"2015-11-17T13:47:02","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=953"},"modified":"2015-11-17T13:47:02","modified_gmt":"2015-11-17T13:47:02","slug":"bge-top-trumps-database","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/11\/17\/bge-top-trumps-database\/","title":{"rendered":"BGE &#8211; Top Trumps Database"},"content":{"rendered":"<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano.png\"><img decoding=\"async\" data-attachment-id=\"954\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2015\/11\/17\/bge-top-trumps-database\/beano\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano.png\" data-orig-size=\"368,589\" 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=\"Beano\" 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\/11\/Beano-187x300.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIBYP98jB7yBkDy7C1Hp8q1jph8%2BO5%2BWADlFTsShan1s9AiEA%2Fb%2FtrAkM%2FlDSqTz%2BtlLb1jybqjS3o0Wsd00mp3%2FSiaoquAUIbxAFGgwyNzM1NzAxOTU0MzMiDBC4W%2BHUcJm5SudfuSqVBcQZSo9CLa%2B1Oy%2BschJI6kFPIel2j3iSPXz%2Fw7LREGD6Ana5PnSzKE3c6yECJ%2BUyohcpRQ0gjRYlMpBh2VUCC0g3B4bJr8AgeND0UggnLjaOLiSbIYlUwGxfvU%2FC9D%2BFtTmVVW7Pvkf0po3%2B%2BEkAghHENzxX2vyVke2RVdDWkEQ75vsglnYg%2BuPKptb5UkNZQH3h%2BxHpeN88zRVgwi9WJ4YzMgnNglzyhFesy4I2c3RpaFFv20CO2lUumbq6VSHicma%2FDU3Ol3CsyvIGe90SQCCPDSJNxoGqgsMi%2Bvdf0WB93S1ji1VVnCzfLcBexN01vh2dHTcLNNkM85MaIM%2Fixc6ny%2BOeTqx%2F30SNf%2FX3rDFhpZqsQAo8VCXmXH7R0qKUwSzhdQuqa9PHmC9ahW9%2FOFMlVkZRGpmOZlqLSOcUtH6AXwrjsm0PMu3b%2BKFDnZEyNfUq1OsV%2BDZqwIVXp06OmdZjhQYe8cnxGKizyA%2BwTqoZw0VCzZfT6yKhcm8rOK4UWHCRG3wLNDPJU8G4kXIKykUq7CGrF7LeYcVMP0U%2Fqkc03D%2FXnsTudp5JTfAZtXlkR7bsX5V1wPVCpGGEswTvTyA%2FLuvfHxsVipDwMP7YehQWk5%2FSV6gmWzqXuV1Tky8fGxA25MreZYwZsRTe9F1rO8FpRWd9Wve4NtXG%2FcBWs4k1qnnAOvJoqrMvA2lnX7JLxHTKK%2BLCQmoR2iRRGe6ODb1OKhXwKZFKsWku3se0t3gt%2F5qcF%2Fd6%2FoiVBhZfzzuk1FVHlu49K20LUCakCawdhI3eJrArXs4D%2FvXIlEK5t0mX00XCd2zKMDI6pAw2JJmogwrBdl8xw1g6W%2BPks%2B3LxR%2BpqScg20NZVxmRlYDN%2FRGLoM5boDUwuMuu1gY6sQGxKdQ3SvhJun3AlL239xhs0mZobFIvM3H1M2YVgfh%2BJJDQQHxuwoFgqEuSDJETJf%2Bd2%2BEOv%2BlzSwTI5MEiXJN3dtEFeHl%2Bw0%2BPYFW%2Bz3UzZwCqSzRTRDKeVVdjA3ckWfmusvYb%2BsIps6i58ER%2FmwPCZMSh2JUYEsG5RINejWUibIohEcebCzDL35shW%2Fp3auX5KGwi2LWCkApby%2B8OqyffPka9LVxpKdozv0UQF0hPy%2FY%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR6CAPVGG%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T151730Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f4acbf5e288bc973324f4a69c10e93c91beed490cea9e6414570a05e79d7e06\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano.png\" class=\"alignleft size-medium wp-image-954\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano-187x300.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIBYP98jB7yBkDy7C1Hp8q1jph8%2BO5%2BWADlFTsShan1s9AiEA%2Fb%2FtrAkM%2FlDSqTz%2BtlLb1jybqjS3o0Wsd00mp3%2FSiaoquAUIbxAFGgwyNzM1NzAxOTU0MzMiDBC4W%2BHUcJm5SudfuSqVBcQZSo9CLa%2B1Oy%2BschJI6kFPIel2j3iSPXz%2Fw7LREGD6Ana5PnSzKE3c6yECJ%2BUyohcpRQ0gjRYlMpBh2VUCC0g3B4bJr8AgeND0UggnLjaOLiSbIYlUwGxfvU%2FC9D%2BFtTmVVW7Pvkf0po3%2B%2BEkAghHENzxX2vyVke2RVdDWkEQ75vsglnYg%2BuPKptb5UkNZQH3h%2BxHpeN88zRVgwi9WJ4YzMgnNglzyhFesy4I2c3RpaFFv20CO2lUumbq6VSHicma%2FDU3Ol3CsyvIGe90SQCCPDSJNxoGqgsMi%2Bvdf0WB93S1ji1VVnCzfLcBexN01vh2dHTcLNNkM85MaIM%2Fixc6ny%2BOeTqx%2F30SNf%2FX3rDFhpZqsQAo8VCXmXH7R0qKUwSzhdQuqa9PHmC9ahW9%2FOFMlVkZRGpmOZlqLSOcUtH6AXwrjsm0PMu3b%2BKFDnZEyNfUq1OsV%2BDZqwIVXp06OmdZjhQYe8cnxGKizyA%2BwTqoZw0VCzZfT6yKhcm8rOK4UWHCRG3wLNDPJU8G4kXIKykUq7CGrF7LeYcVMP0U%2Fqkc03D%2FXnsTudp5JTfAZtXlkR7bsX5V1wPVCpGGEswTvTyA%2FLuvfHxsVipDwMP7YehQWk5%2FSV6gmWzqXuV1Tky8fGxA25MreZYwZsRTe9F1rO8FpRWd9Wve4NtXG%2FcBWs4k1qnnAOvJoqrMvA2lnX7JLxHTKK%2BLCQmoR2iRRGe6ODb1OKhXwKZFKsWku3se0t3gt%2F5qcF%2Fd6%2FoiVBhZfzzuk1FVHlu49K20LUCakCawdhI3eJrArXs4D%2FvXIlEK5t0mX00XCd2zKMDI6pAw2JJmogwrBdl8xw1g6W%2BPks%2B3LxR%2BpqScg20NZVxmRlYDN%2FRGLoM5boDUwuMuu1gY6sQGxKdQ3SvhJun3AlL239xhs0mZobFIvM3H1M2YVgfh%2BJJDQQHxuwoFgqEuSDJETJf%2Bd2%2BEOv%2BlzSwTI5MEiXJN3dtEFeHl%2Bw0%2BPYFW%2Bz3UzZwCqSzRTRDKeVVdjA3ckWfmusvYb%2BsIps6i58ER%2FmwPCZMSh2JUYEsG5RINejWUibIohEcebCzDL35shW%2Fp3auX5KGwi2LWCkApby%2B8OqyffPka9LVxpKdozv0UQF0hPy%2FY%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UR6CAPVGG%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20261011T151730Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=0f4acbf5e288bc973324f4a69c10e93c91beed490cea9e6414570a05e79d7e06\" alt=\"Beano\" width=\"187\" height=\"300\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano-187x300.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIBYP98jB7yBkDy7C1Hp8q1jph8%2BO5%2BWADlFTsShan1s9AiEA%2Fb%2FtrAkM%2FlDSqTz%2BtlLb1jybqjS3o0Wsd00mp3%2FSiaoquAUIbxAFGgwyNzM1NzAxOTU0MzMiDBC4W%2BHUcJm5SudfuSqVBcQZSo9CLa%2B1Oy%2BschJI6kFPIel2j3iSPXz%2Fw7LREGD6Ana5PnSzKE3c6yECJ%2BUyohcpRQ0gjRYlMpBh2VUCC0g3B4bJr8AgeND0UggnLjaOLiSbIYlUwGxfvU%2FC9D%2BFtTmVVW7Pvkf0po3%2B%2BEkAghHENzxX2vyVke2RVdDWkEQ75vsglnYg%2BuPKptb5UkNZQH3h%2BxHpeN88zRVgwi9WJ4YzMgnNglzyhFesy4I2c3RpaFFv20CO2lUumbq6VSHicma%2FDU3Ol3CsyvIGe90SQCCPDSJNxoGqgsMi%2Bvdf0WB93S1ji1VVnCzfLcBexN01vh2dHTcLNNkM85MaIM%2Fixc6ny%2BOeTqx%2F30SNf%2FX3rDFhpZqsQAo8VCXmXH7R0qKUwSzhdQuqa9PHmC9ahW9%2FOFMlVkZRGpmOZlqLSOcUtH6AXwrjsm0PMu3b%2BKFDnZEyNfUq1OsV%2BDZqwIVXp06OmdZjhQYe8cnxGKizyA%2BwTqoZw0VCzZfT6yKhcm8rOK4UWHCRG3wLNDPJU8G4kXIKykUq7CGrF7LeYcVMP0U%2Fqkc03D%2FXnsTudp5JTfAZtXlkR7bsX5V1wPVCpGGEswTvTyA%2FLuvfHxsVipDwMP7YehQWk5%2FSV6gmWzqXuV1Tky8fGxA25MreZYwZsRTe9F1rO8FpRWd9Wve4NtXG%2FcBWs4k1qnnAOvJoqrMvA2lnX7JLxHTKK%2BLCQmoR2iRRGe6ODb1OKhXwKZFKsWku3se0t3gt%2F5qcF%2Fd6%2FoiVBhZfzzuk1FVHlu49K20LUCakCawdhI3eJrArXs4D%2FvXIlEK5t0mX00XCd2zKMDI6pAw2JJmogwrBdl8xw1g6W%2BPks%2B3LxR%2BpqScg20NZVxmRlYDN%2FRGLoM5boDUwuMuu1gY6sQGxKdQ3SvhJun3AlL239xhs0mZobFIvM3H1M2YVgfh%2BJJDQQHxuwoFgqEuSDJETJf%2Bd2%2BEOv%2BlzSwTI5MEiXJN3dtEFeHl%2Bw0%2BPYFW%2Bz3UzZwCqSzRTRDKeVVdjA3ckWfmusvYb%2BsIps6i58ER%2FmwPCZMSh2JUYEsG5RINejWUibIohEcebCzDL35shW%2Fp3auX5KGwi2LWCkApby%2B8OqyffPka9LVxpKdozv0UQF0hPy%2FY%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR6CAPVGG%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T151730Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f4acbf5e288bc973324f4a69c10e93c91beed490cea9e6414570a05e79d7e06 187w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano-94x150.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIBYP98jB7yBkDy7C1Hp8q1jph8%2BO5%2BWADlFTsShan1s9AiEA%2Fb%2FtrAkM%2FlDSqTz%2BtlLb1jybqjS3o0Wsd00mp3%2FSiaoquAUIbxAFGgwyNzM1NzAxOTU0MzMiDBC4W%2BHUcJm5SudfuSqVBcQZSo9CLa%2B1Oy%2BschJI6kFPIel2j3iSPXz%2Fw7LREGD6Ana5PnSzKE3c6yECJ%2BUyohcpRQ0gjRYlMpBh2VUCC0g3B4bJr8AgeND0UggnLjaOLiSbIYlUwGxfvU%2FC9D%2BFtTmVVW7Pvkf0po3%2B%2BEkAghHENzxX2vyVke2RVdDWkEQ75vsglnYg%2BuPKptb5UkNZQH3h%2BxHpeN88zRVgwi9WJ4YzMgnNglzyhFesy4I2c3RpaFFv20CO2lUumbq6VSHicma%2FDU3Ol3CsyvIGe90SQCCPDSJNxoGqgsMi%2Bvdf0WB93S1ji1VVnCzfLcBexN01vh2dHTcLNNkM85MaIM%2Fixc6ny%2BOeTqx%2F30SNf%2FX3rDFhpZqsQAo8VCXmXH7R0qKUwSzhdQuqa9PHmC9ahW9%2FOFMlVkZRGpmOZlqLSOcUtH6AXwrjsm0PMu3b%2BKFDnZEyNfUq1OsV%2BDZqwIVXp06OmdZjhQYe8cnxGKizyA%2BwTqoZw0VCzZfT6yKhcm8rOK4UWHCRG3wLNDPJU8G4kXIKykUq7CGrF7LeYcVMP0U%2Fqkc03D%2FXnsTudp5JTfAZtXlkR7bsX5V1wPVCpGGEswTvTyA%2FLuvfHxsVipDwMP7YehQWk5%2FSV6gmWzqXuV1Tky8fGxA25MreZYwZsRTe9F1rO8FpRWd9Wve4NtXG%2FcBWs4k1qnnAOvJoqrMvA2lnX7JLxHTKK%2BLCQmoR2iRRGe6ODb1OKhXwKZFKsWku3se0t3gt%2F5qcF%2Fd6%2FoiVBhZfzzuk1FVHlu49K20LUCakCawdhI3eJrArXs4D%2FvXIlEK5t0mX00XCd2zKMDI6pAw2JJmogwrBdl8xw1g6W%2BPks%2B3LxR%2BpqScg20NZVxmRlYDN%2FRGLoM5boDUwuMuu1gY6sQGxKdQ3SvhJun3AlL239xhs0mZobFIvM3H1M2YVgfh%2BJJDQQHxuwoFgqEuSDJETJf%2Bd2%2BEOv%2BlzSwTI5MEiXJN3dtEFeHl%2Bw0%2BPYFW%2Bz3UzZwCqSzRTRDKeVVdjA3ckWfmusvYb%2BsIps6i58ER%2FmwPCZMSh2JUYEsG5RINejWUibIohEcebCzDL35shW%2Fp3auX5KGwi2LWCkApby%2B8OqyffPka9LVxpKdozv0UQF0hPy%2FY%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR6CAPVGG%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T151730Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2cf6a9b971f58ce3311fbe96413535ffeb0f70b3084fb7ce14512d4ed6d338be 94w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2015\/11\/Beano.png 368w\" sizes=\"(max-width: 187px) 100vw, 187px\" \/><\/a>Today we analysed a pack of top trumps Beano cards. Pupils were asked to identify field names and types. This was then put into a table before we created the database in Access.<\/p>\n<p>How do you think you would turn this database into a game?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we analysed a pack of top trumps Beano cards. Pupils were asked to identify field names and types. This was then put into a table before we created the database in Access. How do you think you would turn this database into a game?<\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75925,73746],"tags":[],"class_list":["post-953","post","type-post","status-publish","format-standard","hentry","category-broad-general-education","category-structures-and-links-database"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/953","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=953"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/953\/revisions"}],"predecessor-version":[{"id":955,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/953\/revisions\/955"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}