Records (AQA GCSE Computer Science)

Revision Note

Test yourself
James Woodhouse

Written by: James Woodhouse

Reviewed by: Lucy Kirkham

Records

What is a database?

  • A Database is an organised collection of data

  • It allows easy storage, retrieval, and management of information

  • A database is useful when working with large amounts of data, databases are stored on secondary storage

  • A database is often stored on remote servers so multiple users can access it at the same time, useful for online systems

  • Data can be sorted and searched efficiently, making use of more advanced structures

  • They are more secure than text files

  • A database uses fields and records to organise how it stores data

flat-file-table

What are fields & records?

  • A field is one piece of information relating to one person, item or object

  • A field is represented in a database by a column,

  • A record is a collection of fields relating to one person, item or object

  • A record is represented in a database by a row

Text files

  • A text file is useful when working with small amounts of data, text files are stored on secondary storage and 'read' in to a program when being used

  • They are used to store information when the application is closed

  • Each entry is stored on a new line or separated with a special identifier, for example a comma (',')

  • It can be difficult in text files to know where a record begins and ends

"Image coming soon"

Arrays

  • An array is useful when working with small amounts of data, arrays are stored in main memory (RAM)

  • They are used to store information when the application is in use

  • Can be more efficient and much faster to search than working with text files

Last updated:

You've read 0 of your 10 free revision notes

Unlock more, it's free!

Join the 100,000+ Students that ❤️ Save My Exams

the (exam) results speak for themselves:

Did this page help you?

James Woodhouse

Author: James Woodhouse

Expertise: Computer Science

James graduated from the University of Sunderland with a degree in ICT and Computing education. He has over 14 years of experience both teaching and leading in Computer Science, specialising in teaching GCSE and A-level. James has held various leadership roles, including Head of Computer Science and coordinator positions for Key Stage 3 and Key Stage 4. James has a keen interest in networking security and technologies aimed at preventing security breaches.

Lucy Kirkham

Author: Lucy Kirkham

Expertise: Head of STEM

Lucy has been a passionate Maths teacher for over 12 years, teaching maths across the UK and abroad helping to engage, interest and develop confidence in the subject at all levels.Working as a Head of Department and then Director of Maths, Lucy has advised schools and academy trusts in both Scotland and the East Midlands, where her role was to support and coach teachers to improve Maths teaching for all.