Neco 2019 Data Processing obj and essya Answer

WELCOME TO AYOSTUFFS NECO 2019
INVITE YOUR FRIEND AND FAMILY TO AYOSTUFFS.BLOGSPOT.COM WE POST SURE ANSWER



ALWAYS SUBSCRIBE IF YOU WANT FAST ANSWERS/BEFORE THE EXAM…

WE FOCUS MORE ON THE SUBSCRIBERS
BECAUSE THEY ARE THE MORE SERIOUS ONE..
FOR MORE CONTACT US WHATSAPP 07060807249
===============================
KEEP REFRESHING IN EVERY 5MIN
==============================
Data processing obj




1-10 ADCEACCCCE
11-20 ACCDABDEEB
21-30 ADABAACBBA
31-40 ADABAECCEB
41-50 CADAEAEDBA


*DATA PROCESSING*


*Number 1*

(1ai)
Normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.


(1aii)
•  Index searching is often faster, since indexes tend to be narrower and shorter.

• More tables allow better use of segments to control physical placement of data.

• You usually have fewer indexes per table, so data modification commands are faster.



(1bi)
Digital Marketer


(1bii) 
• Google Analytics 
•  Facebook pages manager


(1biii)  
• A solid layout 
•  Effective typography 
• The right color scheme
•  Appropriate  design elements

================

*DATA PROCESSING*
(2ai) 
 A wand is a handheld optical reader that is used to read barcodes as well as typewritten,  printed and OCR fonts.  Wand are used to capture product information for detail and warehouse application. 

(2aii)
Total HD 500GB

Operating System used 20GB and 1.536GB (converting MB to GB) .

Packages used 150 GB

Documents used 150.5GB

Therefore,  the total space used is 322.04(approximately) 
 
Therefore, total HD - total used space = 500 - 322.04 = 177.96GB. 

The total space left on the HD is 177.96GB

(2bi)
 Database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. 

(2bii) 
(i) Unique and non-unique index
(ii) Clustered and non-clustered index
(iii) Partitioned and non-partitioned index


(i) Unique Index: These are indexes that helped  maintain data integrity by ensuring that no two rows of data in a table have identical key values.

=================



No 3ai)

 *Information processing* is the manipulation of data to produce useful information; it involves the capture of information in a format that is retrievable and analyzable. ... Information processing provides individuals with basic skills to use the computer to process many types of information effectively and efficiently

3aii)
 *COMMAND LINE INTERFACE* 
-MS DOS
- DOS

 *GRAPHICAL*
-ANDROID OS
-LINUX
-MACINTOSH
-UNIX

No 3aiii)
What is the difference between Ms DOS and Android OS?

..a) *Ms- Dos* is based on plain interface while *Android* os is based on Graphical user interface (GUI).

b) Ms Dos is difficult to learn and understand while Android os is easy to learn and understand.


3bi)
data model (or data modelling ) is an abstract model that organizes elements of data and standardizes how they relate to one another and to properties of the real world entities.

No 3bii) 
Data processing 

Database model

Collage of five types of database models.

-Flat File Model.

-Hierarchical Model.

-Network Model.

-Two tables with a relationship.

-Object-Oriented Model.


====================


6a)

Three main principles lie behind crash recovery 

 *Write-ahead logging:* 

 Any change to an object is first recorded in the log, and the log must be written to stable storage before changes to the object are written to disk.


 *Repeating history during Redo:* 
On restart after a crash, ARIES retraces the actions of a database before the crash and brings the system back to the exact state that it was in before the crash. Then it undoes the transactions still active at crash time.


 *Logging changes during Undo:* 
 Changes made to the database while undoing transactions are logged to ensure such an action isn't repeated in the event of repeated restarts.

6bi)

A spreadsheet is a sheet of paper that shows accounting or other data in rows and columns; a spreadsheet is also a computer application program that simulates a physical spreadsheet by capturing, displaying, and manipulating data arranged in rows and columns.

6bii)

Three Types of Spreadsheet Databases

A) Simple (or “Gray Cell”) Tables,

B) Excel Tables

C) 
PivotTables with a Tabular Report Layout, introduced in Excel 2010



Comments

Popular posts from this blog

WAEC GCE 2019 CRS/IRS Obj And Essay Answer – August/September Expo

WAEC 2024 Civic Education Obj And Essay Answer – May/June Expo

WAEC 2019 mathematics Obj And Essay Answer – May/June Expo «