Types of databases

Types of databases

1. Flat databases

   • Consists of only one table
   • Not all the information is linked so where there are updates, not all data will alter

2. Relational databases

   • Links all the information together from different tales, without having to repeat data
   • Advantages
     • Mistakes are minimised when handling large amounts of data
     • modifications made with ease
     • Different levels of access
     • Simplicity of design, No mixing different things in a table
   • Features
     • Info separated into discrete entities
       • Based on the real world
       • eg. employee, product, order
     • Entities are described by a series of fields
       • Describes the structure
       • E.g. product name, weight price
     • connected by a series of relationshipds
       • using common field

3. Local databases

   • Only one person can access this database
     • The one person will need a username and password to access it.
     • Certain level of access for said database

4. Network databases

   • More than one person can access
     • There will also need a username and password to access
     • No certain level of accesability

5. Online databases

   • Why they are used?
     • So people can use the updated version
   • Examples
     • eBay
     • Amazon
     • Tesco