Files, Storage & Databases

7 interactive Computer Science simulations on files, storage & databases.

Directory tree – paths and file search Computer Science · Files, Storage & Databases A directory tree you can click to expand, collapse, and select, just like File Explorer. Students pick a file to... Ages 11–12
Database normalisation – from a flat table to 3NF, with ER diagrams Computer Science · Files, Storage & Databases Start from a flat table full of repeated data, trigger update, insert and delete anomalies, then step through 1NF,... Ages 16–17
Relational databases and queries Computer Science · Files, Storage & Databases Two tables, STUDENTS and CLASSES, are linked by the foreign key ClassID pointing to the primary key ClassID of the... Ages 16–17
File Storage – local disk, server or the cloud Computer Science · Files, Storage & Databases The same file is kept in three places: a personal computer's disk, a school server, or a cloud storage service.... Ages 16–17
Data compression and multi-copy backup Computer Science · Files, Storage & Databases A file is compressed three ways: kept as is, compressed losslessly (ZIP, PNG, FLAC), and compressed with loss (JPEG,... Ages 17–18
Secondary storage – magnetic, optical and solid-state devices compared Computer Science · Files, Storage & Databases Look inside three kinds of storage: a hard disk drive (spinning platters, magnetised regions, read/write head, seek... Ages 16–17
How search engines rank results Computer Science · Files, Storage & Databases A small collection of twelve web pages with different titles, URLs, publish dates and trust levels. Students type a... Ages 14–15