Seneca

Structuring Data - Records

Computer Science: OCR GCSE, topic 2.2.16

Records

Structured data is any data that sits in a fixed field within a record or file. Structured data can be easily entered, stored, queried, and analysed.

Records

Records

  • Records are made up of fields.
  • For example, a person could be represented as a record where the fields include their name, age, and address.
Comma separated values (CSV)

Comma separated values (CSV)

  • One method of storing a record is using comma separated values.
  • Each record is put on its own line.
  • Each field is separated by a special character such as a comma.
Pros and cons

Pros and cons

  • Pros:
  • Very simple, text-based format.
  • Can be read by many applications.
  • Easy to use in programs.
  • Cons:
  • Inefficient for large datasets.
  • Can only store text data.
  • No built-in means of sorting or searching.

Test yourself on Structuring Data - Records

  • What are records made up of?

  • Which character separates the values in a CSV file?

  • Cons of CSV files

  • Name the three advantages of storing records as a CSV file.

  • Select the field that appears in the example record of a person.

Practise this topic for free