{"id":332,"date":"2021-03-08T07:44:26","date_gmt":"2021-03-08T07:44:26","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/?p=332"},"modified":"2021-03-08T07:44:26","modified_gmt":"2021-03-08T07:44:26","slug":"s3-computing-science-week-9-work","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/2021\/03\/08\/s3-computing-science-week-9-work\/","title":{"rendered":"S3 Computing Science &#8211; Week 9 Work"},"content":{"rendered":"<p>Relational Databases<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-172\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/bctdepartment\/uploads\/sites\/39533\/2021\/01\/19093240\/images-300x128.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPj%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQD1qG2PWIVLrfgerN%2B4G6FfvBfsFGjU0UE%2FqJDTAy2gqgIhAJDuTNNgafUD1fK78z26Jkp%2FkpLZxprC2voukSpQiA2GKsEFCMH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgxLwqcomJ9mNm%2FsUaMqlQXAaHsudFIKQQNSSM812KiXIerWpLdNJ0bASGVfI%2FCYIon0l%2B%2F4u35Xy%2FJZdYDOD%2Fubkb9YD27MAiJDsBIA2bz8oFQep1iU3Vqr4zAybvekTW8qW4TrcHsH%2F6U95HMTJD4q16VEvZbD97xv%2FPsKaR10PmasPpmyMYV7SFmapH4%2BAN3gJkQenjRDyCZiFj7I7%2FxiulHIGdvNba01sBbsx0pbRXMSDSWRaFmvFmfGIYJpeawWbhsZUuFjot5moq%2BC8FAL7lu44heKygMOByDLT7bmcPXoAmqZt8iJUUs1krW%2FlmW2j6onKCj%2FdBwK1RAcoeUpbrfNWtYAUdSChQwuMg7oCHdX8uo32Iics4%2Fq09zaUmQhmA5j5GHM8s1iizcV97GwF9PSmmQBBsuYBC31nl2itc86RxJ2DY662F3fLuEK%2FUJfY4ohovLOsvpl2zh2yWRPe0zAODYzurSk54%2B2OGJGkHs8b1tOnquo2UzvrJ5cfq57JlU4%2BaFwfEehO7jrW1Fs0IjToX3N1iU5nvrPQKT1%2B7gu8pKwDpcVRJXe%2BAdhZ%2B8l3XIKBQcyltGMxKsuDJQ8H1pG8rKvBAQgx3NS8oxLFQ%2F4Td5nF%2BSW%2FxtuVxVVlLB0LDtMIGzUZcJBpixIFOoWRFehW3dnNNKWSZMqz6J0lwyTadrTENxmAQzlRhKMJDAy7olk2%2Fx%2FWINSTTewHFTjS2JgQ1HWOwPynDaH896GxeYSruhnF2iL%2BjbP17ZWOaRk8zeqMYYrxYLKaZxv14FGrQSMIbvTUqBfeOk%2BZg6DO2d%2BxjbygxMW8s0hh9Xy9LIOSHou%2Bh6b64y27jATZbtdkREcK6rnkt0yzJd%2BeIDNP91ineRTmlbZ2gfnqKQiRPT1tJcEMPiqwNYGOrABVRmNqQAiYmTg8QUF4rlaDRnlH8OJbESZ5ciKhR0B1Ot4I5EK%2FSH3NMhqfNNVZnn1twWpZBQfwsMbFJjTTgPxWREfmXSuNUskYUbQcGJU0jMVfkPeh1R0GOd27zbXWcG05oDvx9RL6MvmrkatZ9UKGiNo73Kln2bTheOrkYME4P6%2F6hZidDIxmJI4sPZTH5T4PyU58oB%2BBxmcMoz8RMm0e4%2B8pHyQx2ZVPVwZNxokpK4%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47USJ2BUHWH%2F20261014%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20261014T235240Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=bb85ccd3477c1d45c1831618b6610d33f50b6358b90850bf14a30630aa85139a\" alt=\"\" width=\"300\" height=\"128\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/bctdepartment\/uploads\/sites\/39533\/2021\/01\/19093240\/images-300x128.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPj%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQD1qG2PWIVLrfgerN%2B4G6FfvBfsFGjU0UE%2FqJDTAy2gqgIhAJDuTNNgafUD1fK78z26Jkp%2FkpLZxprC2voukSpQiA2GKsEFCMH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgxLwqcomJ9mNm%2FsUaMqlQXAaHsudFIKQQNSSM812KiXIerWpLdNJ0bASGVfI%2FCYIon0l%2B%2F4u35Xy%2FJZdYDOD%2Fubkb9YD27MAiJDsBIA2bz8oFQep1iU3Vqr4zAybvekTW8qW4TrcHsH%2F6U95HMTJD4q16VEvZbD97xv%2FPsKaR10PmasPpmyMYV7SFmapH4%2BAN3gJkQenjRDyCZiFj7I7%2FxiulHIGdvNba01sBbsx0pbRXMSDSWRaFmvFmfGIYJpeawWbhsZUuFjot5moq%2BC8FAL7lu44heKygMOByDLT7bmcPXoAmqZt8iJUUs1krW%2FlmW2j6onKCj%2FdBwK1RAcoeUpbrfNWtYAUdSChQwuMg7oCHdX8uo32Iics4%2Fq09zaUmQhmA5j5GHM8s1iizcV97GwF9PSmmQBBsuYBC31nl2itc86RxJ2DY662F3fLuEK%2FUJfY4ohovLOsvpl2zh2yWRPe0zAODYzurSk54%2B2OGJGkHs8b1tOnquo2UzvrJ5cfq57JlU4%2BaFwfEehO7jrW1Fs0IjToX3N1iU5nvrPQKT1%2B7gu8pKwDpcVRJXe%2BAdhZ%2B8l3XIKBQcyltGMxKsuDJQ8H1pG8rKvBAQgx3NS8oxLFQ%2F4Td5nF%2BSW%2FxtuVxVVlLB0LDtMIGzUZcJBpixIFOoWRFehW3dnNNKWSZMqz6J0lwyTadrTENxmAQzlRhKMJDAy7olk2%2Fx%2FWINSTTewHFTjS2JgQ1HWOwPynDaH896GxeYSruhnF2iL%2BjbP17ZWOaRk8zeqMYYrxYLKaZxv14FGrQSMIbvTUqBfeOk%2BZg6DO2d%2BxjbygxMW8s0hh9Xy9LIOSHou%2Bh6b64y27jATZbtdkREcK6rnkt0yzJd%2BeIDNP91ineRTmlbZ2gfnqKQiRPT1tJcEMPiqwNYGOrABVRmNqQAiYmTg8QUF4rlaDRnlH8OJbESZ5ciKhR0B1Ot4I5EK%2FSH3NMhqfNNVZnn1twWpZBQfwsMbFJjTTgPxWREfmXSuNUskYUbQcGJU0jMVfkPeh1R0GOd27zbXWcG05oDvx9RL6MvmrkatZ9UKGiNo73Kln2bTheOrkYME4P6%2F6hZidDIxmJI4sPZTH5T4PyU58oB%2BBxmcMoz8RMm0e4%2B8pHyQx2ZVPVwZNxokpK4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47USJ2BUHWH%2F20261014%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261014T235240Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=bb85ccd3477c1d45c1831618b6610d33f50b6358b90850bf14a30630aa85139a 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/bctdepartment\/uploads\/sites\/39533\/2021\/01\/19093240\/images.jpg 344w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<div>Concepts covered:- SQL Designs<\/div>\n<div><\/div>\n<div>Read pages 9 &amp; 10 of the theory notes and watch the recorded lesson.<\/div>\n<div><\/div>\n<div>Complete the following questions from the homework booklet:-<\/div>\n<div><\/div>\n<div>Q2e on page 5<\/div>\n<div>Q6c on page 15<\/div>\n<div>Q8d on page 22<\/div>\n<div><\/div>\n<div>As always, if you are stuck with anything then get in touch with your teacher via the class channel in MSTeams or contact them directly via email. You can also join the weekly tutorial if you wish on Thursday at 10am.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Relational Databases Concepts covered:- SQL Designs Read pages 9 &amp; 10 of the theory notes and watch the recorded lesson. Complete the following questions from the homework booklet:- Q2e on page 5 Q6c on page 15 Q8d on page 22 As always, if you are stuck with anything then get in touch with your teacher &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/2021\/03\/08\/s3-computing-science-week-9-work\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;S3 Computing Science &#8211; Week 9 Work&#8221;<\/span><\/a><\/p>\n","protected":false},"author":38840,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-332","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/posts\/332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/users\/38840"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/comments?post=332"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/posts\/332\/revisions"}],"predecessor-version":[{"id":333,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/posts\/332\/revisions\/333"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/media?parent=332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/categories?post=332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/bctdepartment\/wp-json\/wp\/v2\/tags?post=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}