Types of database

Types of database

1. relational

   • this doesn't repeat any data and the data is on more than one table so you will not make any mistakes
   • features
     • information separated into discrete entities
       • based on the real world
       • e.g. employee, product, order
     • entities are described by a series of fields
       • describes the structure of the entities
       • e.g. product name, weight , price etc
     • entities are connected by a series of relationships
       • built using common field
       • represented by entity relationship diagrams (ERDs)

2. flatbases

   • just one type of database where everything is on one data table

3. local

   • a local data bases can be used for one or more people but only on can be on at once

4. network

   • a network database allows more than one person to log on over a area

5. online

   • why are they used
     • online data bases are used to store passwords and usernames