Types of Databases

Types of Databases

1. Flat Databases

   • One table
   • Examples
   • Disadvantages
     • Increased Repetition
     • Increased chance of human error

2. Relational Databases

   • More than one table
   • Examples
   • Advantages
     • Reduces Human Error
     • Reduces Redundancy
     • Easily modifiable
     • Easy to control levels of access
   • Features
     • Information separated into different entities
     • About the real world
     • Entities are described by a series of fields
     • Entities are connected by a series of relationships
     • Represented by entity relationship diagrams (EDR's)

3. Local Databases

   • One person only
   • Examples
     • Finance
     • Personal Computer

4. Networked Databases

   • More than one person
   • Examples
     • Employees
     • Students
   • Needs to have:
     • A domain/server
     • Username
     • Password
     • Right level of access

5. Online Databases

   • Examples
     • Amazon
     • Facebook
     • Tesco
   • Why are they used?
     • Can be accessed anywhere when you have:
       • Username
       • Password
       • Internet Connection
     • Can be updated