Types Of Databases

Types Of Databases

1. Flat Databases

   • One table that includes information about everything.
   • Disadvantages
     • It is easy to make mistakes
     • You have to change the information manually everytime if a customer changes information.
   • Advantages
     • Everything is there in one table

2. Relational Databases

   • More than one table
   • Links all the databases together
   • Easy to change the data, you only have to change it once for one person.
   • Less likely to make mistakes
   • Can restrict information for access
   • Features
     • information seperated into discrete entities
       • Based on the real world
     • Entities described by a series of fields
       • Describes the structure of entities
     • Entities connected by a series of relationships
       • Built using common field
       • Represented by entity relationship diagrams

3. Local Databases

   • One person can use it, it is private for the one user

4. Network Databases

   • More than one person can use it, they need a username, password and a level of access so they can see information but not add, edit or delete them.

5. Online Databases

   • Examples
     • Tesco
     • Amazon
     • Ebay
   • Why are they used?
     • To store information
     • Can be accessed anyway
     • They update
     • Accessed on the internet