SS3 1st Term Data Processing scheme of work

                                                            FIRST TERM E-LEARNING NOTE

SUBJECT: DATA PROCESSING                                                                                     CLASS: SS3

SCHEME OF WORK

WEEK                    TOPIC

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

REFERENCE TEXTBOOK: UNDERSTANDING DATA PROCESSING for SENIOR SECONDARY SCHOOLS BY: DINEHIN VICTORIA