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 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)
- 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:
- 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.