File Organisation Amd Access

Question 1

Serial file organisation

Answer 1

• Records of data are physically stored in a file, one after another, in the order they were added to the file
• Suitable for temporary files storing transactions.
• Used for real time processing

Question 2

Sequential file organization

Answer 2

• Records are stored one after another, in a given order
• Appropriate for files with high hit rate
• Order is usually based on the primary field of the records as this is a unique identifier

Question 3

Random file organization

Answer 3

• Records are stored in a file in any available position.
• Real time transaction processing

Question 4

Hashing algorithm

Answer 4

A mathematical formula used to perform calculations on the key field of the record, the result gives the address where record should be found.

Question 5

Sequential file

Answer 5

• If a particular record is being searched for, every record needs to be checked until the record is found or the key field of the current record being checked is greater than the key field of the record being searched for

Question 6

Serial file

Answer 6

• If a particular record is being searched for, every record need to be checked until that record is found or the whole file has been searchers and that record has not been found

Question 7

Direct access

Answer 7

• Jump to a specific record in the file without accessing other records
• Required when only an individual record from a file need to be processed