SS2 Data Processing 1st Term

SS2 DATA PROCESSING 1ST TERM

SS2 Data Processing 1st Term Lesson Note and Scheme of Work by Week

Click on any Week below to jump to its Lesson Note

Attention: The internal data of table “42” is corrupted!

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
Week 1: 18-09-2023

Data Modeling

SUB TOPICS:
A. Introduction to data modeling
B. Types of data modeling

NEW! Exam Questions. Click on
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.

Week 2: 25-09-2023

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

Week 3: 02-10-2023

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.

Week 4: 09-10-2023

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

Week 5: 16-10-2023

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.

Week 6: 23-10-2023

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.

Week 7: 30-10-2023

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!

Please enter your email:

1. Which of the following is not an advantage of file organization? WAEC 2017, Q38

 
 
 
 

2. The process of locating stored data and making them available for use is referred to as —

 
 
 
 

3. Relational database is also known as —

 
 
 
 

4. A network database is a form of database that shows ____ relationship.

 
 
 
 

5. An interactive tool that searches through large volume of text to retrieve information from the internet as —

 
 
 
 

Question 1 of 5

Week 8: 06-11-2023

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

Week 9: 13-11-2023

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

Week 10: 20-11-2023

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.

Attention: The internal data of table “48” is corrupted!

Other Classes are Listed Below
for Data Processing
SS 1 SS 2 SS 3
1st 2nd 3rd 1st 2nd 3rd 1st 2nd 3rd

Scheme of Work by Topic for:
SS2 Data Processing 1st Term
(Ana Arm Technologies)
Data Modeling
Database Normalisation: Normal Forms
Entity Relationship Model
Relational Model
File Organisation
Online Quiz
Reference Textbooks

Trending Post

Select a Category

Senior School e-Classes

Archives

SS One Subjects 1st Term

SS Two Subjects 1st Term

SS Three Subjects 1st Term

NTI PgDE Past Q & A

SS One Subjects 2nd Term

SS Two Subjects 2nd Term

SS Three Subjects 2nd Term

Textbooks and References

SS One Subjects 3rd Term

SS Two Subjects 3rd Term

SSCE Past Questions

TRCN Past Q & A

Youtube Videos

Advertisement

eLearning eClasses eLibrary Solar Energy Training Project Mngmt Solar Robotics

Layer 1
error: Content is protected !!