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.

DATA PROCESSING
(6a)
(i) Analysis: Starts at the last checkpoint in transaction log. This pass determines and constructs a dirty page table (DPT) consisting of pages that might be dirty at the time SQL Server stopped. An active transaction table is built of the uncommitted transactions at the time of the SQL Server stopped also.

(ii) Redo: This phase returns the database to the state at the time the SQL service stopped. Starting point for this forward passbeing the oldest uncommitted transaction. The mininum Log Sequence name (each log record is labelled with an LSN) in the DPT is the first time SQL Server expects to have to redo an operation on a page, redoing the logged operations starting right back at the oldest open transaction so that the neccessary locks can be aquired.

(iii) Undo: Here the list of active transaction (uncommitted at the time SQL Server stoopped) which where indentified in Phase 1 are rolled back individually. SQL Server follows the links between entries in the transaction log for each transaction. Any transaction that was not committed at the time SQL Server stopped is undone.

(6b)
Spreadsheet packages: They are designed to work on specific operating systems, some can be used cross-platform. In other words spreadsheet packages are designed to emulate. Before Excel reached the pinnacle of popularity.

(6bii)
(i) Simple (or “Gray Cell”) Tables, which I’ve used since Excel 2.0.
(ii) Excel Tables, introduced in Excel 2007.
(iii) PivotTables with a Tabular Report Layout, introduced in Excel 2010.

Data Processing Obj
1-10: ADCEACCCCE
11-20: ACCDABDEEB
21-30: ADABAACBBA
31-40: ADABAECCEB
41-50: CADAEAEDBA
51-60:

DATA PROCESSING

(1ai)
Normalization is a process for evaluating and correcting table structures to minimize data redundancies,thereby helping to eliminate data anomalies. it helps in evaluate table structures and produce good table.

(1aii)
(i)Index searching is often faster, since indexes tend to be narrower and shorter.
(ii) More tables allow better use of segments to control physical placement of data.
(iii) You usually have fewer indexes per table, so data modification commands are faster.

(1bi)
Digital Marketer

(1bii)
(i)Google Analytics
(ii)Facebook pages manager

(1biii)
(i)A solid layout
(ii)Effective typography
(iii)The right color scheme
(iv)Appropriate design elements

DATA PROCESSING
(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)
GRAPHICAL
• MS DOS
• DOS

COMMAND LINE INTERFACE
• ANDROID OS
• LINUX
• MACINTOSH
• UNIX

(3aiii)
Ms- Dos is based on plain interface While Android os is based on Graphical user interface (GUI).
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.

(3bii)
• Flat File Model.
• Hierarchical Model.
• Network Model.
• Two tables with a relationship.
• Object-Oriented Model.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.