Types Of Databases

Types Of Databases

1. Flat Databases

   • only 1 table

2. Relational databases

   • More than 1 table that all links together
   • simple design
   • Information separated in to discrete entities
     • based on the real world
   • Entities are described by a series of fields
     • describes the structure of the entities
   • Entities are connected by a series of relationships
     • built using common field
     • Represented by entity relationship diagrams

3. Local Databases

   • 1 person uses it and login is needed

4. Network databases

   • More than 1 person can access it
   • About employees

5. Online databases

   • Companies would use them so their store can be looked at from different locations
   • Amazon, eBay, Sainsbury's, clothes shops etc.
     • Example