{"id":10,"date":"2022-05-05T11:45:21","date_gmt":"2022-05-05T10:45:21","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=10"},"modified":"2022-08-22T10:25:45","modified_gmt":"2022-08-22T09:25:45","slug":"database-design-development","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/database-design-development\/","title":{"rendered":"Database Design Development"},"content":{"rendered":"<h1>Unit Content<\/h1>\n<p><strong>Analysis<\/strong><\/p>\n<p>Identify the end-user and functional requirements of a database<br \/>\nproblem that relates to the implementation at this level.<\/p>\n<p><strong>Design<\/strong><\/p>\n<p>Describe and identify the implications for individuals and businesses<br \/>\nof the UK General Data Protection Regulation (UK GDPR) that data<br \/>\nmust be:<\/p>\n<ul>\n<li>processed lawfully, fairly and in a transparent manner in relation to individuals<\/li>\n<li>used for the declared purpose only<\/li>\n<li>\u00a0limited to the data needed for the declared purpose<\/li>\n<li>\u00a0accurate<\/li>\n<li>not kept for longer than necessary<\/li>\n<li>held securely<\/li>\n<\/ul>\n<p>Describe and exemplify entity-relationship diagrams with two entities indicating:<\/p>\n<ul>\n<li>entity name<br \/>\nattributes<br \/>\nrelationship (one-to-many)<\/li>\n<\/ul>\n<p>Describe and exemplify a data dictionary:<\/p>\n<ul>\n<li>entity name<\/li>\n<li>attribute name<\/li>\n<li>primary and foreign key<\/li>\n<li>attribute type:\n<ul>\n<li>text<\/li>\n<li>number<\/li>\n<li>date<\/li>\n<li>time<\/li>\n<li>Boolean<\/li>\n<li>attribute size<\/li>\n<li>validation:\n<ul>\n<li>presence check<\/li>\n<li>restricted choice<\/li>\n<li>\u00a0field length<\/li>\n<li>range<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Exemplify a design of a solution to the query:<\/p>\n<ul>\n<li>multiple tables<\/li>\n<li>fields<br \/>\nsearch criteria<\/li>\n<li>sort order<\/li>\n<\/ul>\n<p><strong>Implementation <\/strong><\/p>\n<p>Implement relational databases with two linked tables, to match the design with referential integrity.<br \/>\nDescribe, exemplify and implement SQL operations for prepopulated relational databases, with a maximum of two linked tables:<\/p>\n<ul>\n<li>select:\n<ul>\n<li>from<\/li>\n<li>where:\n<ul>\n<li>AND, OR, &lt;, &gt;, =<\/li>\n<li>order by with a maximum of two fields<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>insert<\/li>\n<li>update<\/li>\n<li>delete<\/li>\n<li>\u00a0equi-join between tables<\/li>\n<\/ul>\n<p>Read and explain code that makes use of the above SQL.<\/p>\n<p><strong>Testing <\/strong><\/p>\n<p>Describe and exemplify testing:<\/p>\n<ul>\n<li>SQL operations work correctly at this level<\/li>\n<\/ul>\n<p><strong>Evaluation <\/strong><\/p>\n<p>Evaluate solution in terms of:<\/p>\n<ul>\n<li>\u00a0fitness for purpose<\/li>\n<li>accuracy of output<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Unit Content Analysis Identify the end-user and functional requirements of a database problem that relates to the implementation at this level. Design Describe and identify the implications for individuals and businesses of the UK General Data Protection Regulation (UK GDPR) that data must be: processed lawfully, fairly and in a transparent manner in relation to [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/10","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=10"}],"version-history":[{"count":4,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/10\/revisions"}],"predecessor-version":[{"id":405,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/10\/revisions\/405"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}