{"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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQCi2eqG2jr16rUO6SWvdg2skJeNtDCSTKJ5Lz6n%2BAcHhgIhAJpU1vC3ANWIODVZhjYkqDRWK%2F4KoOWLlAjy49ew%2Fxi4KrkFCE0QBRoMMjczNTcwMTk1NDMzIgzSO%2F3jm12aWW%2B5%2BSgqlgX7nVzvj1FSy%2BU3Rgt9AfjnMXHijEzF%2Bo5v%2BzvNJueGdJyPMuCIqipx9eUhPpq%2Fb%2B4rIHhguAaUeeajHvzhYs76fp0XmsCp1tHjik98Ef52AMbciczaC1CG%2Fan7g6QiBkbznijh%2Be1B%2FoBrQkbbgymrVdR4cFAAQerbdGw4qOu1qd%2BCCTusxSkpWLPODw4nW8Xjk%2Bj5vbUsgKevHpxrovZkcvfg%2Bj0DubD2Re0KRPtfhtVQ3rcTBOWpIEQhJL2HCLqONXPby3QNNMl5TPxC0havOiPYG1TYAkZdZuUYJbd%2FP5Q4SQ%2BwzoNxMWeBl7VBveIU8peTXQsSbRHebvd8rSoGOpBPpbZFooUtnBaDYIF8bMsVHjt74w48AurexVJK5RUV0D38qfmOsG7FkOKehE7uJxcGqvoI8uXY9wvRlEC%2FY1gSP4a5ne6V5XPbp2ctwK60s0pu0gXbtOl2UDyqmmcQHY%2BhipIJfJTZuNc84tV6r%2BKqETbWeJKsx3WH5trIQHBguclyWBbDy4tWIOaRZLHwkdTUIHasfW02XbaAs6vFB9r8Qi6Tb1eAdXijavJzbEgN65zyHn9dGNjuXWVsStbnD1%2Fc%2B6y55zNlihFagv5Su7FpIqUODMISvyHe%2B0m98FxTvZ4ISzCnjtC3ysQj7qSNtVHkHmud%2FUlYTY7DC9eS9Ufhugj613Kmb5SVO7tDUdXx5cc00TfhPJvF1Hgw13vZCiPEavtKevR77B1cFkT%2FBazLBMx4BYiOLrLtEQwtl%2FOYiXItaObE4LAyPmlerAMbG4PsGm9EcgcOEgiM6jhCUx5jVG70xOxvD7077t%2BgE32ZAr0zBQA%2BeMi%2FWuXOSJp54gQL4yO7zigKPUArtvb%2BQPdCrA%2BkAjC6iLzRBjqwAVypvbALDSbpmx2sR1fBlc1REj%2BHoypC4aNcjjjpDG1aZgWunM431pSCZB6FTHvez6ZWue0e1zyXIAFgXtWAvPp8NBFBNPs6y5p1yJZgxmnQPZYSMD78shFppVQ%2FPfuiph479q6kE38s1bH7b8H%2FuxubpGpUl%2BgVPNtktfJAuW7aK8YYm8xSHu%2Bmo9vObNKlQ54xW2xOOQvW4KMSClW8ft72tUeb3C382Wfvp15eGN5R&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UYF3EKDG7%2F20260614%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260614T202038Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=07c00ee2a1b3c387bfc514c0ef57d52e17a2670aa634bb47e95c402bad3ee04a\" 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=IQoJb3JpZ2luX2VjEIT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQCi2eqG2jr16rUO6SWvdg2skJeNtDCSTKJ5Lz6n%2BAcHhgIhAJpU1vC3ANWIODVZhjYkqDRWK%2F4KoOWLlAjy49ew%2Fxi4KrkFCE0QBRoMMjczNTcwMTk1NDMzIgzSO%2F3jm12aWW%2B5%2BSgqlgX7nVzvj1FSy%2BU3Rgt9AfjnMXHijEzF%2Bo5v%2BzvNJueGdJyPMuCIqipx9eUhPpq%2Fb%2B4rIHhguAaUeeajHvzhYs76fp0XmsCp1tHjik98Ef52AMbciczaC1CG%2Fan7g6QiBkbznijh%2Be1B%2FoBrQkbbgymrVdR4cFAAQerbdGw4qOu1qd%2BCCTusxSkpWLPODw4nW8Xjk%2Bj5vbUsgKevHpxrovZkcvfg%2Bj0DubD2Re0KRPtfhtVQ3rcTBOWpIEQhJL2HCLqONXPby3QNNMl5TPxC0havOiPYG1TYAkZdZuUYJbd%2FP5Q4SQ%2BwzoNxMWeBl7VBveIU8peTXQsSbRHebvd8rSoGOpBPpbZFooUtnBaDYIF8bMsVHjt74w48AurexVJK5RUV0D38qfmOsG7FkOKehE7uJxcGqvoI8uXY9wvRlEC%2FY1gSP4a5ne6V5XPbp2ctwK60s0pu0gXbtOl2UDyqmmcQHY%2BhipIJfJTZuNc84tV6r%2BKqETbWeJKsx3WH5trIQHBguclyWBbDy4tWIOaRZLHwkdTUIHasfW02XbaAs6vFB9r8Qi6Tb1eAdXijavJzbEgN65zyHn9dGNjuXWVsStbnD1%2Fc%2B6y55zNlihFagv5Su7FpIqUODMISvyHe%2B0m98FxTvZ4ISzCnjtC3ysQj7qSNtVHkHmud%2FUlYTY7DC9eS9Ufhugj613Kmb5SVO7tDUdXx5cc00TfhPJvF1Hgw13vZCiPEavtKevR77B1cFkT%2FBazLBMx4BYiOLrLtEQwtl%2FOYiXItaObE4LAyPmlerAMbG4PsGm9EcgcOEgiM6jhCUx5jVG70xOxvD7077t%2BgE32ZAr0zBQA%2BeMi%2FWuXOSJp54gQL4yO7zigKPUArtvb%2BQPdCrA%2BkAjC6iLzRBjqwAVypvbALDSbpmx2sR1fBlc1REj%2BHoypC4aNcjjjpDG1aZgWunM431pSCZB6FTHvez6ZWue0e1zyXIAFgXtWAvPp8NBFBNPs6y5p1yJZgxmnQPZYSMD78shFppVQ%2FPfuiph479q6kE38s1bH7b8H%2FuxubpGpUl%2BgVPNtktfJAuW7aK8YYm8xSHu%2Bmo9vObNKlQ54xW2xOOQvW4KMSClW8ft72tUeb3C382Wfvp15eGN5R&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UYF3EKDG7%2F20260614%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260614T202038Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=07c00ee2a1b3c387bfc514c0ef57d52e17a2670aa634bb47e95c402bad3ee04a 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/bctdepartment\/uploads\/sites\/39533\/2021\/01\/19093240\/images.jpg 344w\" sizes=\"auto, (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}]}}