🏗️ Structure

File based structure

Data grouped based on a type of file. One file is storing the data in a logical organised format.

example

- Spreadsheets
AKA - Flat file

Directory based structure

Data in files within separate organised folders. Folders tend to be hierarchical.

example

Like a tree

Relational database model

Organises data into table, which can be linked based on data common to each. It allows you to retrieve an entirely new table from one or more tables with a single query.

Advantages

- Flexibility
ㅤ- Allows you to make changes while it's running
- Ease of backup and disaster recovery
- Speed
- Security
- Multi-User
- Organised data in separate tables

Disadvantages

- Cost
ㅤ- The cost is expensive. There needs to be separate software
- Can be slow
ㅤ- Based on storage
- Can be complex
ㅤ- Vast amounts of data, lots of information to be stored.
ㅤㅤ- Many tables