Neco 2017 Data Processing Question 4

Practice essay / theory question 4 from the 2017 Neco Data Processing examination. This question covers Types of Files, File Organization .

Neco 2017 Data Processing Essay / Theory
Topics: Types of Files File Organization
Question 4 NECO • 2017 • DATA_PROCESSING • essay

A small business sells handmade crafts online. Its computer stores information about products, customers, and sales transactions. The current file system is described as follows: - All files are kept in a single folder called "ShopData" on the desktop. - Product details are saved in a plain‑text file named "products.txt". - Customer records are stored in a Microsoft Access database file "customers.accdb". - Photographs of each product are saved as JPEG images (e.g., "item01.jpg"). - Sales transactions are recorded in a spreadsheet "sales.xlsx". Answer the questions that follow.

Question Parts

( a )
Classify each of the following as a text file, a binary file, or a database file: (i) product catalogue stored as a .txt file, (ii) sales transactions stored in a Microsoft Access database, (iii) product images stored as .jpg files.
( b )
The business currently keeps all files in the single folder "ShopData". Discuss two disadvantages of this file‑organization method.
( c )
Recommend an appropriate hierarchical folder structure for the business. Specify at least three levels of folders and indicate the type of files that should be stored in each. Justify how this structure supports efficient file retrieval and backup.
( d )
Explain the difference between sequential file organization and indexed file organization. Indicate which would be more suitable for storing the sales‑transaction file and why.

Detailed Solution & Marking Scheme

Get the step-by-step solution, key points required by examiners and detailed marking guidance through the Edcrib AI Tutor.

Reveal Answer

About This Question

This is Neco 2017 Data Processing Question 4. It is one of the essay questions from the 2017 Neco Data Processing examination.

The question covers Types of Files, File Organization .

View More Neco 2017 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support