{"id":1635,"date":"2017-05-24T08:20:13","date_gmt":"2017-05-24T08:20:13","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?page_id=1635"},"modified":"2018-09-20T19:41:52","modified_gmt":"2018-09-20T18:41:52","slug":"database-design-and-development","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/national-5\/database-design-and-development\/","title":{"rendered":"Database Design and Development"},"content":{"rendered":"\n\n\n\n\n\n\n\n
\n

Topic<\/h2>\n<\/td>\n

\n

Database Design and Development (DDD) – National 5 (v2.1)<\/h2>\n<\/td>\n<\/tr>\n

\n

Analysis<\/h3>\n<\/td>\n

Identify the end-user and functional requirements of a database problem that relates to the implementation at this level.<\/td>\n<\/tr>\n
\n

Design<\/h3>\n<\/td>\n

Describe and identify the implications for individuals and businesses of the General Data Protection Regulation (GDPR)<\/a> \u2014 Regulation (EU) 2016\/679<\/a> that data must be:<\/p>\n
    \n
  • processed lawfully, fairly and in a transparent manner in relation to individuals<\/li>\n
  • used for the declared purpose only<\/li>\n
  • limited to the data needed for the declared purpose<\/li>\n
  • accurate<\/li>\n
  • not kept for longer than necessary<\/li>\n
  • held securely<\/li>\n<\/ul>\n

    Describe and exemplify entity relationship diagrams with two entities indicating:<\/p>\n

      \n
    • entity name<\/li>\n
    • attributes<\/li>\n
    • relationship (one to many)<\/li>\n<\/ul>\n

      Describe and exemplify a data dictionary:<\/p>\n

        \n
      • entity name<\/li>\n
      • attribute name<\/li>\n
      • primary and foreign key<\/li>\n
      • attribute type:\n
          \n
        • text<\/li>\n
        • number<\/li>\n
        • date<\/li>\n
        • time<\/li>\n
        • Boolean<\/li>\n<\/ul>\n<\/li>\n
        • attribute size<\/li>\n
        • validation:\n
            \n
          • presence check<\/li>\n
          • restricted choice<\/li>\n
          • field length<\/li>\n
          • range<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            Exemplify a design of a solution to the query:<\/p>\n

              \n
            • multiple tables<\/li>\n
            • fields<\/li>\n
            • search criteria<\/li>\n
            • sort order<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
\n

Implementation<\/h3>\n<\/td>\n

\n
    \n
  • database structure: field, record, file<\/span><\/li>\n
  • field types<\/span>\n
      \n
    • text<\/span><\/li>\n
    • number<\/span><\/li>\n
    • date\/time<\/span><\/li>\n
    • graphic<\/span><\/li>\n
    • calculated<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

      Implement relational databases with two linked tables, to match the design with referential integrity.<\/p>\n

      Describe, exemplify and implement SQL operations for prepopulated relational databases, with a maximum of two linked tables:<\/p>\n

        \n
      • SELECT<\/li>\n
      • FROM<\/li>\n
      • WHERE<\/li>\n
      • AND, OR, <, >, =<\/li>\n
      • ORDER BY with a maximum of two fields<\/li>\n
      • INSERT<\/li>\n
      • UPDATE<\/li>\n
      • DELETE<\/li>\n
      • equi-join between tables<\/li>\n<\/ul>\n

        Read and explain code that makes use of the above SQL.<\/td>\n<\/tr>\n

\n

Testing<\/h3>\n<\/td>\n

 <\/p>\n

Describe and exemplify testing:<\/p>\n

    \n
  • SQL operations work correctly at this level<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
\n

Evaluation<\/h3>\n<\/td>\n

 <\/p>\n

Evaluate solution in terms of:<\/p>\n

    \n
  • fitness for purpose<\/li>\n
  • accuracy of output<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    * Taken from National 4 Specifications<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    Topic Database Design and Development (DDD) – National 5 (v2.1) 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 General Data Protection Regulation (GDPR) \u2014 Regulation (EU) 2016\/679 that data must be: processed …<\/p>\n","protected":false},"author":32,"featured_media":0,"parent":181,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1635","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/1635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/types\/page"}],"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=1635"}],"version-history":[{"count":10,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/1635\/revisions"}],"predecessor-version":[{"id":2113,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/1635\/revisions\/2113"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/181"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=1635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}