🏗️ Structure

File based structure:

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

Eg:

• Spreadsheets
  

AKA: Flat file (one file with all information and data in it)

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 its running
• Ease of backup and disaster resovery
• 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