{"id":1815,"date":"2017-11-03T10:05:57","date_gmt":"2017-11-03T10:05:57","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=1815"},"modified":"2017-11-03T10:05:57","modified_gmt":"2017-11-03T10:05:57","slug":"higher-database-learning-points","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2017\/11\/03\/higher-database-learning-points\/","title":{"rendered":"Higher &#8211; Database Learning Points"},"content":{"rendered":"<p>We have now finished Databases. Here is what you should know.<\/p>\n<p>From <a href=\"http:\/\/scholar.hw.ac.uk\/\">Scholar<\/a><\/p>\n<ul>\n<li>\n<blockquote><p>How to describe the structure of a database in terms of tables, records and fields.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>The advantages of using relational databases.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>The purpose of primary, surrogate, foreign and compound keys.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>The differences between one-to-one, one-to-many and many-to-many relationships.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>The purpose and uses of tables, forms and reports.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>What is meant by a relationship in a database.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>How to perform complex operations, such as performing a query, creating a form,\u00a0creating a report.<\/p><\/blockquote>\n<\/li>\n<li>\n<blockquote><p>A calculated field is one which is created using a query which calculates a result from\u00a0one or more existing fields.<\/p><\/blockquote>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>We have now finished Databases. Here is what you should know. From Scholar How to describe the structure of a database in terms of tables, records and fields. The advantages of using relational databases. The purpose of primary, surrogate, foreign and compound keys. The differences between one-to-one, one-to-many and many-to-many relationships. The purpose and uses &hellip;<\/p>\n","protected":false},"author":32,"featured_media":1386,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[432061,319],"tags":[],"class_list":["post-1815","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-design-and-development","category-oldhigher"],"jetpack_featured_media_url":"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2016\/09\/Slide4.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1815","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=1815"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1815\/revisions"}],"predecessor-version":[{"id":1816,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1815\/revisions\/1816"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media\/1386"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=1815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=1815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=1815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}