{"id":1974,"date":"2018-05-24T11:27:52","date_gmt":"2018-05-24T11:27:52","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?page_id=1974"},"modified":"2018-09-20T19:25:32","modified_gmt":"2018-09-20T18:25:32","slug":"database-design-and-development","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/higher\/database-design-and-development\/","title":{"rendered":"Database Design and Development"},"content":{"rendered":"\n\n\n\n\n\n\n\n\n
\n

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

\n

Database Design and Development (DDD) – Higher (v2.1)<\/h2>\n<\/td>\n<\/tr>\n<\/thead>\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 exemplify entity-relationship diagrams with three or more entities, indicating:<\/p>\n
    \n
  • entity name<\/li>\n
  • attributes<\/li>\n
  • name of relationship<\/li>\n
  • cardinality of relationship (one-to-one, one-to-many, many-to-many)<\/li>\n<\/ul>\n

    Describe and exemplify an instance using an entity-occurrence diagram.<\/p>\n

    Describe and exemplify a compound key.<\/p>\n

    Describe and exemplify a data dictionary with three or more entities:<\/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 a query:<\/p>\n

            \n
          • tables and queries<\/li>\n
          • fields<\/li>\n
          • search criteria<\/li>\n
          • sort order<\/li>\n
          • calculations<\/li>\n
          • grouping<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
\n

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

Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables:<\/p>\n
    \n
  • UPDATE, SELECT, DELETE, INSERT statements making use of:\n
      \n
    • wildcards<\/li>\n
    • aggregate functions (MIN, MAX, AVG, SUM, COUNT)<\/li>\n
    • computed values, alias<\/li>\n
    • GROUP BY<\/li>\n
    • ORDER BY<\/li>\n
    • WHERE<\/li>\n<\/ul>\n<\/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

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

Evaluate solution at this level 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

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Topic Database Design and Development (DDD) – Higher (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 exemplify entity-relationship diagrams with three or more entities, indicating: entity name attributes name of relationship cardinality of relationship (one-to-one, one-to-many, many-to-many) Describe and exemplify …<\/p>\n","protected":false},"author":32,"featured_media":1386,"parent":763,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1974","page","type-page","status-publish","has-post-thumbnail","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/1974","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=1974"}],"version-history":[{"count":5,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/1974\/revisions"}],"predecessor-version":[{"id":2110,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/1974\/revisions\/2110"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/pages\/763"}],"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=1974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}