SS2 Data Processing 1st Term Lesson Note and Scheme of Work by Week
Click on any Week below to jump to its Lesson Note
Announcement for Students in:
SS One, SS Two & SS Three, First Term
Study Online & Get
Better SSCE (WAEC & NECO) Results
Than in Tutorial Classes
Tutorial or Home lesson may not be so effective in your quest for academic excellence, especially when you have the opportunity to access our content-rich, well-formatted e-Notes, Video Lessons, Voice Notes, etc
Data Modeling
SUB TOPICS:
A. Introduction to data modeling
B. Types of data modeling
SS2 Biology 2nd Term to get started.
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 State the meaning of data modeling.
2 List and discuss types of data modeling with the aid of diagrams.
3 Explain the meaning of relational, hierarchical, object oriented, and flat data modelings.
Data Modeling (CONT'D)
SUB TOPICS:
A. Creating Tables, Forms, Queries and Reports
B. Table structure and concept of Primary Key
C. Types of Forms
D. Building blocks of a Form – the fields
E. Significance of data modeling
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Create a table structure and add tables to a database.
2 Create a form and link it to a database table.
3 Use a Simple Query wizard to create a query.
4 Identify and discuss four major objects in Microsoft Access.
5 ETC
Data Modeling (CONT'D)
SUB TOPICS:
A. Introduction to standard data model
B. Examples of standard data model
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 State the meaning of standard data model.
2 List examples of standard data model.
Database Normalisation: Normal Forms
SUB TOPICS:
A. Meaning of norminalisation
B. Definition and types of normal form
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Give examples of tables in first and second normal tables.
2 State the problems of tables in first normal form.
3 Describe the following first, second, and third normal forms.
4 Explain foreign key and primary key.
5 ETC
Database Normalisation: Normal Forms (CONT'D)
SUB TOPICS:
A. Problems of table in first normal form
B. Determinants of normal forms
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Highlight and explain the problems of table in first normal form.
2 Identify any determinants, other than the primary key, and the columns they determine.
Database Normalisation: Normal Forms (CONT'D)
SUB TOPICS:
A. Importance of normalisation
B. Advantages and disadvantages of normalisation
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Highlight the significance of normalisation.
2 List the advantages of normalisation.
3 State the disadvantages of normalisation.
SS2 Data Processing 1st Term Revision and Mid Term Test
Take a Quiz on SS2 Data Processing 1st Term
It does not require sign up or login. But a correct and valid e-mail will help the quiz machine send you the questions and answers when you click SUBMIT. Cheers!
Relational Model
SUB TOPICS:
A. Creating and modifying relations using SQL
B. Integrity constraints over relations
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 List steps for creating and modifying relations using SQL.
2 State and explain the two parts of an SQL.
3 Highlight the importance of using a SQL in a database.
4 List and explain different types of SQL statements.
5 ETC
Relational Model (CONT'D)
SUB TOPICS:
A. Enforcing integrity constraints
B. Querying relational data
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Identify and explain different types of constraints.
2 Write a SQL NOT NULL constraint.
3 Write a SQL UNIQUE KEY constraint.
4 Write a SQL PRIMARY KEY constraint.
5 ETC
File Organization
SUB TOPICS:
A. Meaning and features of a file
B. Definition and importance of file organisation
C. Methods or types of file organization
D. Characteristics of file organization.
LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Explain the meaning and features of a file.
2 Define and state the importance of file organisation.
3 List and explain different types of file organizations.
4 Highlight the characteristics of file organization.
(Ana Arm Technologies)
Data Modeling
Database Normalisation: Normal Forms
Entity Relationship Model
Relational Model
File Organisation
Online Quiz
Reference Textbooks
Quick Links to
SS 2 Subjects 1st Term
SS 2 Accounting 1st Term SS 2 Agric Science 1st Term
SS 2 Animal Husbandry 1st Term
SS 2 Biology 1st Term
SS 2 Chemistry 1st Term
SS 2 Civic Education 1st Term
SS 2 Commerce 1st Term
SS 2 Computer Science 1st Term
SS 2 Computer Studies 1st Term
SS 2 Data Processing 1st Term
SS 2 Economics 1st Term
SS 2 English Language 1st Term
SS 2 Government 1st Term
SS 2 Marketing 1st Term
SS 2 Mathematics 1st Term
SS 2 Physics 1st Term