Difference Between File Stock System And File Inventory System

1298 Words 6 Pages
FILE ORGANISATION AND FILE ACCESS
Review: Storage devices can be categorized according the manner in which they access data. There are two types of access: 1. Sequential access (the retrieval of data in
…show more content…
There is rarely one way of solving the problem, but here are some typical examples.  A payroll is a list of all the employees in an organization, together with their pay details. Every month a payroll application will calculate how much each person should be paid. It will print payslips and it may send the details of payments directly to the company’s bank. The payroll file would normally be stored sequentially by surname. When the application is run each month it will access the record for each employee one at a time, so a simple sequential file is needed.  A shop uses a computerized stock system. The stock records hold details of all the items for sale in the shop. Each item is identified by a stock code. The stock record for each item also holds the price of the item and the number in stock. When a customer wants to buy an item the sales assistant enters the stock code at a point of sale terminal. (A barcode reader can be used to scan in the stock code from a label on the item.) The stock system then finds the record for the item and sends the price to the point of sale terminal. It also updates the stock record to show that the number in stock has gone down. There will be a large number of records in the stock file, and each item has to be retrieved quickly, so the best way to organize the file would be as a random file.  A library has a computer-based catalogue of all its books. The catalogue is sorted by the ISBN (International Standard Book Number) which you can find on the back of any book that has been published. There is usually a barcode that gives the ISBN as well. When someone borrows the book the librarian scans the ISBN barcode and this brings up the details of the book on screen. The catalogue file is large but is stored sequentially. Index-sequential

Related Documents