{"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=IQoJb3JpZ2luX2VjEGgaCWV1LXdlc3QtMSJIMEYCIQD9hOqc7RfRN%2BPFDW4BC%2F%2BtwpqtMKE5n2JzFROyJgexcQIhAO7QzHVQmIc7cckJeT1rmRVEmBGIoMYs8ExSqBn9ZVJyKrgFCDEQBRoMMjczNTcwMTk1NDMzIgynh0mmt1XRJsuqN8sqlQUm5WD21%2FoXxA2tYBQ7M%2BlJUjNB3MbfUwewk0FINU3XnvNcYrKcelwuZpr6%2BxA95jGAs8yrsYOGY7GIuCFwkp1DeYoNEnqfNmzZM%2Bf8jwGsRbBPee9Tfxj3z5c%2FOTdmqmm%2B4JwBhH4YR36K5OeGwRYfWXUknZDjDmD8mdxbNdGBNlgMFZeZr2KwhdX2tQnq8IXpjrE67HIa0%2B85H3DnVRi0za1LLiTDrY%2BuWjSFHDOIMHCoXyVD%2FGM%2BlQ9mDyyNZBcj62xP26Aow6RrfW8yBbHYdGO4m%2FV%2FcRoeBKuZxS1Orjdw67HtKRc1XOUyCi01y2Oes7azw6k1A1YC%2B%2BamECerhY8Z635K0IerDXN%2FOIi9GIGAM52q1oUS63bgxPIQab%2FlDcMrgiiXvd5qRXRxavlgt%2BacrlxK3MIA9HVDgjc6Q%2FpA%2BwTcXd%2BPpVvZRtCSaF%2Ff8IkJ1abLQ102YgJogQjYSPND5sK1a%2FAwNTEOu8ngLrLkgs%2Fgr7c6sRWMRyUTXQXDWEpMcTfVoIPDvOv%2BqPe9hRCdUyhm7hCG%2B%2B7R8YAoN8HaDMtOx20MsoGpNBPzO%2FYCYpJF0ncOiKJCaxfBAMfv5hUbOmZwwWxdN4HxOsc84pO9tqsZrOB6B8mkSVDBE1rzlqrGsLfac2KnB1dC1MP1%2Bbt%2Bg9Q1y4%2BTZqh8F00vr4O91S7yXU9bDDiR51RlzwOpgvBzIfTmrvujdWjkrFwXb1%2FH%2F%2F8%2F%2FeSN%2BybWk0vS5C0pILzSDicV6gjZp54hWXEO%2FJQQDQDaLVro6A7oACLrKs8qUnq6HBYBICD3WAyjL1crX77k9Cio6ivk0M3I9DD1b%2FBi5GAzqlj4%2BM5%2FISW37s1%2Frtdv63Xuv8vq6LWd%2FfgYZ10%2BMJ6%2BptIGOrABiV7hAEZN%2FiWXdRBzLxv7WNcSFJ1OG2f9ASVOvcJNb0zB%2B2Fte2D2ppJSC491qcUpj9rAOKEoqXLwLXnvVYWm7mPks1%2FrGJMqEMBbLR9vpyC%2BgFniODoN0fwzEvlWAL6Gte%2FajCtn7rx1Fe21sJdvxKzqkeVu7i8FnZfoEnFEuis6tRLnexETjcBJilfrefFYe7p0cBlLVQA1pZxFACEHsc7TCa2RqrxDKU%2BGrjUd%2BqU%3D&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47U4EGQEVGM%2F20260705%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260705T002744Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=b4552f3eb88aafe03526064a8de5cf4582a5de7801f27b92cae295640ec5f8af\" 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=IQoJb3JpZ2luX2VjEGgaCWV1LXdlc3QtMSJIMEYCIQD9hOqc7RfRN%2BPFDW4BC%2F%2BtwpqtMKE5n2JzFROyJgexcQIhAO7QzHVQmIc7cckJeT1rmRVEmBGIoMYs8ExSqBn9ZVJyKrgFCDEQBRoMMjczNTcwMTk1NDMzIgynh0mmt1XRJsuqN8sqlQUm5WD21%2FoXxA2tYBQ7M%2BlJUjNB3MbfUwewk0FINU3XnvNcYrKcelwuZpr6%2BxA95jGAs8yrsYOGY7GIuCFwkp1DeYoNEnqfNmzZM%2Bf8jwGsRbBPee9Tfxj3z5c%2FOTdmqmm%2B4JwBhH4YR36K5OeGwRYfWXUknZDjDmD8mdxbNdGBNlgMFZeZr2KwhdX2tQnq8IXpjrE67HIa0%2B85H3DnVRi0za1LLiTDrY%2BuWjSFHDOIMHCoXyVD%2FGM%2BlQ9mDyyNZBcj62xP26Aow6RrfW8yBbHYdGO4m%2FV%2FcRoeBKuZxS1Orjdw67HtKRc1XOUyCi01y2Oes7azw6k1A1YC%2B%2BamECerhY8Z635K0IerDXN%2FOIi9GIGAM52q1oUS63bgxPIQab%2FlDcMrgiiXvd5qRXRxavlgt%2BacrlxK3MIA9HVDgjc6Q%2FpA%2BwTcXd%2BPpVvZRtCSaF%2Ff8IkJ1abLQ102YgJogQjYSPND5sK1a%2FAwNTEOu8ngLrLkgs%2Fgr7c6sRWMRyUTXQXDWEpMcTfVoIPDvOv%2BqPe9hRCdUyhm7hCG%2B%2B7R8YAoN8HaDMtOx20MsoGpNBPzO%2FYCYpJF0ncOiKJCaxfBAMfv5hUbOmZwwWxdN4HxOsc84pO9tqsZrOB6B8mkSVDBE1rzlqrGsLfac2KnB1dC1MP1%2Bbt%2Bg9Q1y4%2BTZqh8F00vr4O91S7yXU9bDDiR51RlzwOpgvBzIfTmrvujdWjkrFwXb1%2FH%2F%2F8%2F%2FeSN%2BybWk0vS5C0pILzSDicV6gjZp54hWXEO%2FJQQDQDaLVro6A7oACLrKs8qUnq6HBYBICD3WAyjL1crX77k9Cio6ivk0M3I9DD1b%2FBi5GAzqlj4%2BM5%2FISW37s1%2Frtdv63Xuv8vq6LWd%2FfgYZ10%2BMJ6%2BptIGOrABiV7hAEZN%2FiWXdRBzLxv7WNcSFJ1OG2f9ASVOvcJNb0zB%2B2Fte2D2ppJSC491qcUpj9rAOKEoqXLwLXnvVYWm7mPks1%2FrGJMqEMBbLR9vpyC%2BgFniODoN0fwzEvlWAL6Gte%2FajCtn7rx1Fe21sJdvxKzqkeVu7i8FnZfoEnFEuis6tRLnexETjcBJilfrefFYe7p0cBlLVQA1pZxFACEHsc7TCa2RqrxDKU%2BGrjUd%2BqU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4EGQEVGM%2F20260705%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260705T002744Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b4552f3eb88aafe03526064a8de5cf4582a5de7801f27b92cae295640ec5f8af 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}]}}