Types of databases

Types of databases

1. flat databases

   • This has just one table that holds all information together.
   • Easier to make mistakes
   • Repeat information

2. relational databases

   • This database has more than one table.
   • Separate tables to store different pieces of information.
   • Less likely to make mistakes
   • Features
     • Information separated into discrete entities
       • Based on the real world
       • e.g employees , products, orders
     • Entities are described by a series of fields
       • Describes the structure of all entities
       • e.g product name, prices, weight
     • Entities are connected by a series of relationships
       • Built using common field
       • Represented by entity relationship diagrams (EDRs)

3. local databases

   • One person uses it, all information stored is private. This would be good for information such as finance.

4. Network databases

   • Multiple people use it, to do this they need a server

5. Online databases

   • Examples: Tesco,Amazon,Barclays..
   • Why are they used?
     • They are used too store any information that needs too be put online,to do this you will need a email and a password so the account you are using know who you are
       • Advantage: Easy too access if you have a internet connection
       • Disadvantage: If you don't have a internet connection