{"id":3738,"date":"2023-10-05T18:37:43","date_gmt":"2023-10-05T18:37:43","guid":{"rendered":"http:\/\/localhost\/ecole9ja\/?p=3738"},"modified":"2023-10-05T18:43:26","modified_gmt":"2023-10-05T18:43:26","slug":"week-1-ss3-first-term-data-processing-notes","status":"publish","type":"post","link":"https:\/\/ecolebooks.com\/nigeria\/posts\/week-1-ss3-first-term-data-processing-notes\/","title":{"rendered":"Week 1 – SS3 First Term Data Processing Notes"},"content":{"rendered":"

FIRST TERM E-LEARNING NOTE
\n<\/strong>
\n\u00a0SUBJECT: DATA PROCESSING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0CLASS: SS3
\n<\/strong>
\n\u00a0SCHEME OF WORK
\n<\/strong>
\n\u00a0WEEK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TOPIC
\n<\/strong><\/p>\n

    \n
  1. REVISION\n<\/li>\n
  2. INDEXES:- Definition, Clustered versus Unclustered indexes\n<\/li>\n
  3. INDEXES:- Dense versus Sparse, Primary and Secondary Indexes, Indexes using Composite Search Keys\n<\/li>\n
  4. MAINTENANCE OF COMPUTER:- Computer Hardware, Process Of Maintaining Hardware\n<\/li>\n
  5. MAINTENANCE OF COMPUTER:- Procedure for Software Maintenance, Software for Hardware and Software Maintenance\n<\/li>\n
  6. DATABASE SECURITY:- Definition and Explanation, Access Control and Encryption\n<\/li>\n
  7. DATABASE SECURITY:- Importance, Integrity and Availability, the Role of a Database Administrator\n<\/li>\n
  8. CRASH RECOVERY:- Introduction to ARIES, other Recovery Related Data Structure.\n<\/li>\n
  9. CRASH RECOVERY:- Definition and Explanation of Check Pointing, Explain Media Recovery\n<\/li>\n
  10. REVISION\n<\/li>\n
  11. EXAMINATION\n<\/li>\n<\/ol>\n

    REFERENCE TEXTBOOK: UNDERSTANDING DATA PROCESSING for SENIOR SECONDARY SCHOOLS BY: DINEHIN VICTORIA
    \nWEEK ONE
    \n<\/strong>REVISION
    \n<\/strong>DEFINITION OF DATA MODEL
    \nIs the process of structuring and organizing data.<\/p>\n

    \u00a0TYPES OF DATA MODELS
    \n(1) Flat (2) Hierarchical (3) Network (4) Relational (5) Object-Relational and (6)Star Schema <\/p>\n

    \u00a0SIGNIFICANCE OF DATA MODEL
    \n(1) A well-developed data model can foster improved understanding of the organization
    \n(2) Data model helps in structuring and organizing of data
    \n(3) It imposes constraints or limitations on the data placed within the structure<\/p>\n

    \u00a0STANDARD DATA MODEL
    \nA standard data model or industry standard data model is a data model that is widely applied in some industry and shared amongst competitors to some degree. Examples are: ISO 10303, ISO 15926, IDEAS GROUP<\/p>\n

    \u00a0NORMALIZATION
    \nIs the process of efficiently organizing data in a database by reducing duplication or redundancy and design flaws.<\/p>\n

    \u00a0NORMAL FORM
    \nProvide criteria for determining a table’s degree of vulnerability to logical inconsistencies and anomalies.<\/p>\n

    \u00a0CLASSES OF NORMAL FORM
    \n1st<\/sup>, 2nd<\/sup>, 3rd<\/sup>, BNC, 4th<\/sup> and 5th<\/sup> normal forms<\/p>\n

    \u00a0DETERMINANT OF NORMAL FORM
    \n(1) The minimal number of attributes necessary to support the data requirements of the enterprise
    \n(2) Attributes with a close logical relationship are found in the same relation
    \n(3) Minimal redundancy with each attribute represented only once with the important exception of attributes that form all or part of foreign keys.<\/p>\n

    \u00a0EVALUATION<\/strong>
    \n\t\t1. Define data model
    \n2. State types of data model<\/p>\n

    \u00a0CONCEPT OF KEYS<\/p>\n

    \u00a0PRIMARY KEY
    \nIs the attribute used to identify a record uniquely in a table or database<\/p>\n

    \u00a0COMPOSITE PRIMARY KEY
    \nTwo or more keys used as a primary key<\/p>\n

    \u00a0FOREIGN KEY
    \nIs the field or attribute of a table that matches the primary key of another table.<\/p>\n

    \u00a0ENTITY RELATIONSHIP DIAGRAM (ERD)
    \nIs the diagram that illustrates the logical structure of a database.<\/p>\n

    \u00a0Components of Entity-Relationship (1) Entities (2) Attributes (3) Relationships<\/p>\n

    \u00a0ENTITY
    \nIs anything for which data can be written about in a business.<\/p>\n

    \u00a0ATTRIBUTES
    \nAre data elements that have the smallest units of data that can be described in a meaningful manner.<\/p>\n

    \u00a0RELATIONSHIP
    \nIs an association among the instances of one or more entity types<\/p>\n

    \u00a0CARDINALITY
    \nDefines the relationships between the entities in terms of numbers.<\/p>\n

    \u00a0TYPES OF RELATIONSHIP
    \nOne-to-One, One-to-Many, Many-to-Many<\/p>\n

    \u00a0GENERAL EVALUATION
    \n<\/strong><\/p>\n

      \n
    1. \n
      (a) Define data model?\n<\/div>\n

      (b) State types of data model
      \n(c) Use the following data to draw a hierarchical data model: Fruit; Orange, Pear, Berry; Lime, Grape,Avocado, Sour Sop, Raspberry, Cranberry [Hints: Lime and Grape are children of Orange, Avocado, and SoarSopare children of Pear while Raspberry and Cranberry are children of Berry]\n<\/li>\n

    2. \n
      (a) State five (5) classes of normal forms\n<\/div>\n

      (b) Bring the table below to Second Normal Form\n<\/li>\n<\/ol>\n

      \u00a0TABLE_PURCHASE<\/p>\n

      \n\n\n\n\n\n\n\n\n
      CustomerID<\/td>\nStoreID<\/td>\nPurchase Location<\/td>\n<\/tr>\n
      1<\/td>\n1<\/td>\nLagos<\/td>\n<\/tr>\n
      1<\/td>\n3<\/td>\nKano<\/td>\n<\/tr>\n
      2<\/td>\n1<\/td>\nLagos<\/td>\n<\/tr>\n
      3<\/td>\n2<\/td>\nAbuja<\/td>\n<\/tr>\n
      4<\/td>\n3<\/td>\nKano<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

      Hint: This table has a composite primary key [CustomerID, StoreID]<\/p>\n

      \u00a0WEEKEND ASSIGNMENT
      \n<\/strong><\/p>\n

        \n
      1. Data models describe \u2026\u2026\u2026 data for storage in data management systems (a) structured (b) unstructured (c) integer (d) alphabetic\n<\/li>\n
      2. \n
        Which of this is not an example of standard data model (a) ISO 10303 (b) ISO 15926 (c) IDEAS GROUP d) Good shepherd\n<\/div>\n<\/li>\n
      3. \u2026\u2026\u2026.. key is a field in a relational table that matches a primary key of another table (a) foreign (b) surrogate (c) primary (d) candidate\n<\/li>\n
      4. \u2026\u2026\u2026\u2026\u2026. is graphical representation of entities and their relationships to each other (a) Entity-Relationship Diagram (b) Entity-Relationship Picture (c) Entity-Relationship Data (d) Entity-Relationship Symbol \u00a0\u00a0\u00a0\u00a0\n<\/li>\n
      5. \n
        A roof covers a building describes \u2026\u2026\u2026\u2026relationship (a) one-to-one (b) one-to-many (c) many-to-many(d) none of the above\n<\/div>\n<\/li>\n<\/ol>\n

        \u00a0THEORY
        \n<\/strong><\/p>\n

          \n
        1. \n
          (a) Define the following terms (i) Entity (ii) Attribute (iii) Relationship\n<\/div>\n

          (b) What is cardinality?
          \n(c) Mention and explain three types of relationship in ERD with one example each\n<\/li>\n

        2. \n
          (a) Define the following (i) Primary key (ii) Foreign key (iii) Composite primary key\n<\/div>\n

          (b) Explain the term Normal Form.
          \n(c) Design a database of your choice indicating the primary key and the foreign key\n<\/li>\n<\/ol>\n


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

          FIRST TERM E-LEARNING NOTE \u00a0SUBJECT: DATA PROCESSING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0CLASS: SS3 \u00a0SCHEME OF WORK \u00a0WEEK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TOPIC REVISION INDEXES:- Definition,…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,291],"tags":[],"class_list":["post-3738","post","type-post","status-publish","format-standard","hentry","category-posts","category-first-term-ss3-data-processing"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/3738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/comments?post=3738"}],"version-history":[{"count":1,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/3738\/revisions"}],"predecessor-version":[{"id":3739,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/posts\/3738\/revisions\/3739"}],"wp:attachment":[{"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/media?parent=3738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/categories?post=3738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecolebooks.com\/nigeria\/wp-json\/wp\/v2\/tags?post=3738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}