{"id":76,"date":"2019-11-11T01:49:02","date_gmt":"2019-11-11T01:49:02","guid":{"rendered":"http:\/\/learnlearn.uk\/alevelcs\/?page_id=76"},"modified":"2021-03-26T03:54:59","modified_gmt":"2021-03-26T03:54:59","slug":"database-management-systems","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/","title":{"rendered":"Features of DBMS"},"content":{"rendered":"<h3><\/h3>\n<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Dictionary<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Data Dictionary<\/h3>\n<p>As well as storing the data itself, a database also stores metadata (data about data) as well. This is stored in the data dictionary and includes:<\/p>\n<ul>\n<li>The names of all the tables<\/li>\n<li>The column names for all of the tables<\/li>\n<li>The data types for all the columns in each table<\/li>\n<li>Data constraints within the tables (e.g. whether a field allows a NULL value)<\/li>\n<\/ul>\n<div id=\"attachment_1837\" style=\"width: 467px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/visual-editing-of-the-data-dictionary.png\"><img aria-describedby=\"caption-attachment-1837\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1837\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/visual-editing-of-the-data-dictionary.png\" alt=\"\" width=\"457\" height=\"288\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/visual-editing-of-the-data-dictionary.png 457w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/visual-editing-of-the-data-dictionary-300x189.png 300w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><p id=\"caption-attachment-1837\" class=\"wp-caption-text\">The data dictionary can be edited visual using the DBMS<\/p><\/div>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Modelling<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Database Modelling &amp; Schema<\/h3>\n<h4>Data Modelling &amp; Logical Schema<\/h4>\n<p>Data modelling can be conducted visually using a Database Management System&#8217;s in-built modelling and is an important feature of a database management system.<\/p>\n<p><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/database-schema-modelling.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1836\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/database-schema-modelling.png\" alt=\"\" width=\"477\" height=\"270\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/database-schema-modelling.png 477w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/database-schema-modelling-300x170.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Views<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Custom Views for different users<\/h3>\n<p>The database management system can be used to present different views of the database to different users.<\/p>\n<p>Depending on who is accessing the database they might be able to view all data on the database, view only certain data and have write access. These views often consist of forms and reports<\/p>\n<p><strong>Form Views<\/strong><\/p>\n<p><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form.png\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1833\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form.png\" alt=\"\" width=\"536\" height=\"329\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form.png 536w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form-300x184.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p><strong>Report Views<\/strong><\/p>\n<div id=\"attachment_1839\" style=\"width: 739px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/users-report-generated-by-libre-base-DBMS.png\"><img aria-describedby=\"caption-attachment-1839\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-1839 size-full\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/users-report-generated-by-libre-base-DBMS.png\" alt=\"\" width=\"729\" height=\"199\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/users-report-generated-by-libre-base-DBMS.png 729w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/users-report-generated-by-libre-base-DBMS-300x82.png 300w\" sizes=\"(max-width: 729px) 100vw, 729px\" \/><\/a><p id=\"caption-attachment-1839\" class=\"wp-caption-text\">The output from a report generated by the DBMS<\/p><\/div>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Security<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Database Security &amp;\u00a0 Integrity<\/h3>\n<p>Relational databases have a number of security advantages over flat file systems.<\/p>\n<p><strong>Automatic Backups<\/strong><\/p>\n<p>Relational databases can be configured to automatically backup to both local and remote storage, while preserving the database integrity. This is useful if multiple backups need to be merged to restore from a database corruption event.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Access Rights for users \/groups<\/strong><\/p>\n<p>Individual users or groups of users can be given varying access to the database depending on their level and job role. Members of departments can be limited in what data they can access and also the nature of that access (such as read \/ write \/ execute \/ delete \/ append access). This allows for granular and compartmentalised design and control of the database system.<\/p>\n<p><strong>Query Log<\/strong><\/p>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Interfaces<\/h2>\n<div class=\"tabcontent\">\n\n<h3>DBMS Interfaces<\/h3>\n<p>There are 3 types of interfaces that the DBMS provide:<\/p>\n<ul>\n<li>User Interface<\/li>\n<li>Administrator Interface<\/li>\n<li>Developer Interface<\/li>\n<\/ul>\n<h4>User Interface<\/h4>\n<p>This interface is designed for the end user. Input and viewing high controlled using\u00a0 User Access Levels (UAL) so that they can only view and edit data related to their account. This inter<\/p>\n<div id=\"attachment_1833\" style=\"width: 546px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form.png\"><img aria-describedby=\"caption-attachment-1833\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1833\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form.png\" alt=\"\" width=\"536\" height=\"329\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form.png 536w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/libre-office-add-user-form-300x184.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><p id=\"caption-attachment-1833\" class=\"wp-caption-text\">Add new user form. An example of the user interface.<\/p><\/div>\n<h4>Administrator Interface<\/h4>\n<p>The administrator interface is designed to allow a greater amount of access and functionality than the user interface but without needed to know how to execute SQL queries.<\/p>\n<div id=\"attachment_1834\" style=\"width: 421px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/editing-entries-into-the-users-table-using-the-administrator-interface.png\"><img aria-describedby=\"caption-attachment-1834\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-1834 size-full\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/editing-entries-into-the-users-table-using-the-administrator-interface.png\" alt=\"\" width=\"411\" height=\"210\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/editing-entries-into-the-users-table-using-the-administrator-interface.png 411w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/editing-entries-into-the-users-table-using-the-administrator-interface-300x153.png 300w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/a><p id=\"caption-attachment-1834\" class=\"wp-caption-text\">Example of the database administrator interface. Here existing tuples in the users table can be edited.<\/p><\/div>\n<p>&nbsp;<\/p>\n<h4>Developer Interface<\/h4>\n<p>Access to the developer interface allows detailed inspection of the database contents and metadata to be performed, mainly through the use of custom crafted SQL queries that can be executed within the developer interface.<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_1814\" style=\"width: 541px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/developer-interface-advanced-view.png\"><img aria-describedby=\"caption-attachment-1814\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1814\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/developer-interface-advanced-view.png\" alt=\"\" width=\"531\" height=\"203\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/developer-interface-advanced-view.png 531w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/developer-interface-advanced-view-300x115.png 300w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/a><p id=\"caption-attachment-1814\" class=\"wp-caption-text\">Advanced Queries can be written directly using the SQL text based interface<\/p><\/div>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Query Processor<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Query Processor<\/h3>\n<p>The job of the query processor is to take the query text passed to it by other modules in the DBMS, parse the data and execute it in the appropriate manner.<\/p>\n<ul>\n<li>DDL Queries, such CREATE &amp; DROP, are passed to the DDL interpreter which then reads\/modifies the contents of the data dictionary.<\/li>\n<li>DML Queries, such as SELECT &amp; INSERT, are passed to the DML compiler. These queries are compiled, optimised and then executed by the query engine.<\/li>\n<\/ul>\n<div id=\"attachment_1815\" style=\"width: 689px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/query-by-example-libre-base-example.png\"><img aria-describedby=\"caption-attachment-1815\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1815\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/query-by-example-libre-base-example.png\" alt=\"\" width=\"679\" height=\"586\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/query-by-example-libre-base-example.png 679w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/query-by-example-libre-base-example-300x259.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><p id=\"caption-attachment-1815\" class=\"wp-caption-text\">Simple queries can be created using a Query By Example GUI Interface<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_1796\" style=\"width: 560px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/How-SQL-Queries-are-handled-using-the-query-processor.png\"><img aria-describedby=\"caption-attachment-1796\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1796\" src=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/How-SQL-Queries-are-handled-using-the-query-processor.png\" alt=\"\" width=\"550\" height=\"428\" srcset=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/How-SQL-Queries-are-handled-using-the-query-processor.png 550w, https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/How-SQL-Queries-are-handled-using-the-query-processor-300x233.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><p id=\"caption-attachment-1796\" class=\"wp-caption-text\">The Query processor pathways for DML and DDL Queries<\/p><\/div>\n\n<\/div><h2 class=\"tabtitle\">Resources<\/h2>\n<div class=\"tabcontent\">\n\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.bbc.co.uk\/bitesize\/guides\/zb2hgk7\/revision\/1\">https:\/\/www.bbc.co.uk\/bitesize\/guides\/zb2hgk7\/revision\/1<\/a><\/p>\n<p><a href=\"https:\/\/docs.google.com\/presentation\/d\/1-GHHlgVRMu6XnmoNllIrcTxYOkZLRajXVz3j6tRLiBA\/edit?usp=sharing\">Teacher Presentation<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Data Dictionary As well as storing the data itself, a database also stores metadata (data about data) as well. This is stored in the data dictionary and includes: The names of all the tables The column names for all of the tables The data types for all the columns in each table Data constraints within&hellip;&nbsp;<a href=\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Features of DBMS<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"on","neve_meta_content_width":75,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Features of DBMS - A Level Computer Science<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Features of DBMS - A Level Computer Science\" \/>\n<meta property=\"og:description\" content=\"Data Dictionary As well as storing the data itself, a database also stores metadata (data about data) as well. This is stored in the data dictionary and includes: The names of all the tables The column names for all of the tables The data types for all the columns in each table Data constraints within&hellip;&nbsp;Read More &raquo;Features of DBMS\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/\" \/>\n<meta property=\"og:site_name\" content=\"A Level Computer Science\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-26T03:54:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/visual-editing-of-the-data-dictionary.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/\",\"name\":\"Features of DBMS - A Level Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#website\"},\"datePublished\":\"2019-11-11T01:49:02+00:00\",\"dateModified\":\"2021-03-26T03:54:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"A Level Computer Science Home\",\"item\":\"https:\/\/learnlearn.uk\/alevelcs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Features of DBMS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#website\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/\",\"name\":\"A Level Computer Science\",\"description\":\"CIE Specification\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/alevelcs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#organization\",\"name\":\"A Level Computer Science\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"A Level Computer Science\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Features of DBMS - A Level Computer Science","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/","og_locale":"en_GB","og_type":"article","og_title":"Features of DBMS - A Level Computer Science","og_description":"Data Dictionary As well as storing the data itself, a database also stores metadata (data about data) as well. This is stored in the data dictionary and includes: The names of all the tables The column names for all of the tables The data types for all the columns in each table Data constraints within&hellip;&nbsp;Read More &raquo;Features of DBMS","og_url":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/","og_site_name":"A Level Computer Science","article_modified_time":"2021-03-26T03:54:59+00:00","og_image":[{"url":"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/11\/visual-editing-of-the-data-dictionary.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/","url":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/","name":"Features of DBMS - A Level Computer Science","isPartOf":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/#website"},"datePublished":"2019-11-11T01:49:02+00:00","dateModified":"2021-03-26T03:54:59+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/alevelcs\/database-management-systems\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"A Level Computer Science Home","item":"https:\/\/learnlearn.uk\/alevelcs\/"},{"@type":"ListItem","position":2,"name":"Features of DBMS"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/alevelcs\/#website","url":"https:\/\/learnlearn.uk\/alevelcs\/","name":"A Level Computer Science","description":"CIE Specification","publisher":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/alevelcs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/alevelcs\/#organization","name":"A Level Computer Science","url":"https:\/\/learnlearn.uk\/alevelcs\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"A Level Computer Science"},"image":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/alevelcs\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Data Dictionary As well as storing the data itself, a database also stores metadata (data about data) as well. This is stored in the data dictionary and includes: The names of all the tables The column names for all of the tables The data types for all the columns in each table Data constraints within&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages\/76"}],"collection":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":20,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages\/76\/revisions"}],"predecessor-version":[{"id":1840,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages\/76\/revisions\/1840"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/media?parent=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}