{"id":812,"date":"2024-12-05T13:00:32","date_gmt":"2024-12-05T13:00:32","guid":{"rendered":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/?post_type=product&#038;p=812"},"modified":"2025-01-09T11:08:42","modified_gmt":"2025-01-09T11:08:42","slug":"aqa-gcse-8525-slr-14-relational-databases-and-sql","status":"publish","type":"product","link":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/product\/aqa-gcse-8525-slr-14-relational-databases-and-sql\/","title":{"rendered":"AQA GCSE (8525) SLR 14 &#8211; Relational databases and SQL"},"content":{"rendered":"<p>It includes:<\/p>\n<ul>\n<li><del><\/del>Student Learning Record Workbook (for use by students)<\/li>\n<li>Student Learning Record Answers (for use by teachers)<\/li>\n<li>End of Topic test and answers<\/li>\n<li>Lesson PowerPoint\u2019s for every lesson<\/li>\n<li>Any associated answers or references sheets for class activities<\/li>\n<\/ul>\n<p>This topic covers:<\/p>\n<p>3.7.1 Relational databases<\/p>\n<ul>\n<li>Explain the concept of a database.<\/li>\n<li>Explain the concept of a relational database.<\/li>\n<li>Understand the following database concepts:<br \/>\ntable<br \/>\nrecord<br \/>\nfield<br \/>\nprimary key<br \/>\nforeign key<\/li>\n<li>Understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy.<\/li>\n<\/ul>\n<p>3.7.2 Structured query language (SQL)<\/p>\n<ul>\n<li>Be able to use SQL to retrieve data from a relational database.<\/li>\n<li>Be able to use SQL to insert data into a relational database.<\/li>\n<li>Be able to use SQL to edit and delete data in a database.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This download provides you with a zip file which contains all the resources you will need to deliver this topic.<\/p>\n","protected":false},"featured_media":842,"template":"","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"product_brand":[],"product_cat":[59],"product_tag":[],"class_list":{"0":"post-812","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-aqa-gcse-8525-paper-2","8":"first","9":"instock","10":"downloadable","11":"virtual","12":"taxable","13":"product-type-simple"},"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/product\/812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/media\/842"}],"wp:attachment":[{"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/media?parent=812"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/product_brand?post=812"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/product_cat?post=812"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pennstudiostaging.co.uk\/craig-n-dave\/wp-json\/wp\/v2\/product_tag?post=812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}