{"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=IQoJb3JpZ2luX2VjEJT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCIDfw2Lr9gWK4Fv0XEQhyvL%2FVs6tO%2BtTMIMzTxBo3UtSTAiB4XA81WfzLV5gzA7l%2F0o39AR7Cy8BPWtN6dCC%2Fayb6TSq5BQhdEAUaDDI3MzU3MDE5NTQzMyIMlQtX5W4fY73hZaIDKpYFBc1GY6qm5f%2FiWdv3ho5520E%2FQZcN7Tp%2FvxtILnzRtdulirtAlu2h6uecOTmSgGlDX%2BHRpzTLGhsk%2BXzTjGlmuCBPut17ljB5spiLUoU6t2FBmvEuJbt11ClENPyp%2BPyU40z%2FegwoWelLi63bndEbxqXcJNv6AvsVInRcCcNMqe%2BCk1wC6%2F06cU%2FnCYhKHBbVHhsF96j%2BDoCToRCMQg%2FzjWpJxowKlbYYGffTII1jCIO0vIGqm%2FkkNafl%2F9MXRamf7Oyv1IyzgWvDC%2FVviEMhXtfNiyUV7oLzJ2xhXPJV2U6ANY%2FHi0SzzQzrRxqrbOlej2lUJ7FTD3UKapEtaNOB5iAqd%2FtqU5jOOz0tGNzvLRm3PNA4%2Bpaimb08yuNO19wMXBfKHhvxuwekM1bhk0Kg%2B8VnEbK4J%2Bk1jNDzTvE2fTm7H0SgGQHsc%2FQcAeJpSYTXW0sc5HozoD4tFFjbCu4qRUwYPxkoxii4b4Z9UicBFQ8a6pSKHklOF%2Bk3nLYpylHVSmJGObuNBXyekIZ18Jz0BTzT%2FWgGNGOYOqgF9RoWm7E11uvch5%2BW%2B2%2Frh9o1wV8OI%2B6bWXpHJkBai%2FrItIotcHTPf3mjojgIWLYsxSg5hbNcVfiMUEz31zPOb7pIoJU7IurWsJOFSPFGHfYb4Dz5WFbi3cke4S%2Fj3rngGkaW2JlpsSnZQyfSadVY79VEwF3JWE3MnwJjdbD00xAyJk6rncY1khl4l2WWEs1mAMkA1R5QmIf0lDLvuTfqzskiygXYYINvT4j1O4jXkcqQP0bG%2FZ6NweeoO5ZjsOEjTivy3tPSFQDDRYv6Koxd1uSl8tN%2FDOQAHhuPNsKkAAyHylB7k2GG9qSm4yOxF8TDmMbAFf9fSxObTpMw85LP0AY6sgEU0G%2FRP9NbpBGoQ80rlYa5thevrgtpX98vqV0tiEuMvvoQBkKhg3vlLtuQ%2F5rpB6VqEg%2FIUKDcxRXxq4ebKvqflRz7i9253DRm9kaEorcEJs0WF3wlw5qbTBfYA6PaGAhTp2yScnFio1AQnSCqQAwcVRm0SDnkvB8tKp%2F8Bjo2LvQrIvKNsKwcI0H6O8fT0cSfM4NdZZsDecCAxw%2F%2Fjjg6waIMdBzQkICg%2B%2F%2FyE7WcYtbY&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47USEVKU6R4%2F20260525%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260525T042513Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=21ba650e234f65501b508734f89c290345a366c5b2abe46eee276466c0a5f092\" 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=IQoJb3JpZ2luX2VjEJT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCIDfw2Lr9gWK4Fv0XEQhyvL%2FVs6tO%2BtTMIMzTxBo3UtSTAiB4XA81WfzLV5gzA7l%2F0o39AR7Cy8BPWtN6dCC%2Fayb6TSq5BQhdEAUaDDI3MzU3MDE5NTQzMyIMlQtX5W4fY73hZaIDKpYFBc1GY6qm5f%2FiWdv3ho5520E%2FQZcN7Tp%2FvxtILnzRtdulirtAlu2h6uecOTmSgGlDX%2BHRpzTLGhsk%2BXzTjGlmuCBPut17ljB5spiLUoU6t2FBmvEuJbt11ClENPyp%2BPyU40z%2FegwoWelLi63bndEbxqXcJNv6AvsVInRcCcNMqe%2BCk1wC6%2F06cU%2FnCYhKHBbVHhsF96j%2BDoCToRCMQg%2FzjWpJxowKlbYYGffTII1jCIO0vIGqm%2FkkNafl%2F9MXRamf7Oyv1IyzgWvDC%2FVviEMhXtfNiyUV7oLzJ2xhXPJV2U6ANY%2FHi0SzzQzrRxqrbOlej2lUJ7FTD3UKapEtaNOB5iAqd%2FtqU5jOOz0tGNzvLRm3PNA4%2Bpaimb08yuNO19wMXBfKHhvxuwekM1bhk0Kg%2B8VnEbK4J%2Bk1jNDzTvE2fTm7H0SgGQHsc%2FQcAeJpSYTXW0sc5HozoD4tFFjbCu4qRUwYPxkoxii4b4Z9UicBFQ8a6pSKHklOF%2Bk3nLYpylHVSmJGObuNBXyekIZ18Jz0BTzT%2FWgGNGOYOqgF9RoWm7E11uvch5%2BW%2B2%2Frh9o1wV8OI%2B6bWXpHJkBai%2FrItIotcHTPf3mjojgIWLYsxSg5hbNcVfiMUEz31zPOb7pIoJU7IurWsJOFSPFGHfYb4Dz5WFbi3cke4S%2Fj3rngGkaW2JlpsSnZQyfSadVY79VEwF3JWE3MnwJjdbD00xAyJk6rncY1khl4l2WWEs1mAMkA1R5QmIf0lDLvuTfqzskiygXYYINvT4j1O4jXkcqQP0bG%2FZ6NweeoO5ZjsOEjTivy3tPSFQDDRYv6Koxd1uSl8tN%2FDOQAHhuPNsKkAAyHylB7k2GG9qSm4yOxF8TDmMbAFf9fSxObTpMw85LP0AY6sgEU0G%2FRP9NbpBGoQ80rlYa5thevrgtpX98vqV0tiEuMvvoQBkKhg3vlLtuQ%2F5rpB6VqEg%2FIUKDcxRXxq4ebKvqflRz7i9253DRm9kaEorcEJs0WF3wlw5qbTBfYA6PaGAhTp2yScnFio1AQnSCqQAwcVRm0SDnkvB8tKp%2F8Bjo2LvQrIvKNsKwcI0H6O8fT0cSfM4NdZZsDecCAxw%2F%2Fjjg6waIMdBzQkICg%2B%2F%2FyE7WcYtbY&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47USEVKU6R4%2F20260525%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260525T042513Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=21ba650e234f65501b508734f89c290345a366c5b2abe46eee276466c0a5f092 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}]}}