week 5

Data formats:

• file-based structure:

o data held within one file

o consistent set of attributes, data types and validation

o context is held within the file

o data is referenced within the file

o data stored in flat file format

 

• directory-based structure:

o data held across multiple files

o contains multiple attributes, data types and validation

o context held within the file and the structure

o relational data is referenced across multiple files

o datasets are extracted from system and filtered

o data can be structured in a hierarchy system

o allows multiple data owners and sources

• relational database systems:

o data organised using normalisation to reduce redundancy

o data connect by relationships

o structured query language (SQL)/data processing language

o server-client implementation

Importance for analysis:

 

• easier to query

 

• easier to keep up to date

 

• supports with drawing conclusions

 

• allows sharing of data


Last Updated
2023-03-29 12:25:37

Links to Learning Outcomes

Links to Assessment criteria

 

R3.5 Characteristics of data formats and importance for analysis.



English


Maths







How 2's Coverage

Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.



Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.

Files that support this week


| | | | |
Week 4
Prev
Week 5
Prev
Week 6
Prev

Next

Next
Webmaster Spelling Notifications