Information Technology:Programming. A record is a collection of related data which is stored in a field and treated as a single entity for processing.

Authors Avatar

Files  and  records need to be organized so that the are easily accessible and easy to update when necessary.

A record is a collection of related data which is stored in a field and treated as a single entity for processing.

A field contains a single data item

Many fields comprise a record.

Each field has a name and one is the key field used to identify the record

A data file is a collection of records holding  the same type of information but about different objects or individuals

A  file  has  3  important  characteristic- Whether  it is permanent or temporary

File organization:the way in which a file is organized on the  secondary storage device.

Way in which records are accessed or located

MASTER AND TRANSACTION FILE.

Master file is a permanent file,kept up to date and used to store main information,date summary and key fields in the data.

They are two types of data in master file,they are:

Permanent data such as Employees personal information

Less Permanent Date which is updated on a regular basis such as hour worked.

Transaction file is a temporary file used to update the master file at a specific period e.g at the end of a week.It updates the master file.The records of transaction file perform 3 main operation

Join now!

Add:a record to master file

Update change the content of the records or fields in master file

Delete:remove a record from  the master file.

Transaction log or change file is a file that keeps track of the changes to the transaction file

SERIAL AND SEQUENTIAL FILE ORGANISATION

In Serial File Organization records are rearranged one after another in the order in which they were added.NB:The records are not sort in any particular order.

Example:Unsorted invoices for customer for one day,a typical shopping list

Serial Files can be stored on tape,dish or memory.Used mainly for backup.

In sequential ...

This is a preview of the whole essay