Types of Databases

Types of Databases

1. Flat databases

   • a flat database is a database that Is one table that contains simple information, however can carry a lot of errors such as calculation errors, information errors and also can take a lot of time up.

2. Relational databases

   • Relational is several databases containing personal information, items, idem numbers. Relation databases contain less errors and also has item numbers that links with the price and description, this allows it easier for delivery company's as they can edit information and also get information up a lot faster and simpler.
   • Features
     • Information separated into discrete entities
       • Based on the real world
     • Entities are described by a series of feilds
       • Describe the structure of the entities
         • E.g product name, weight price
     • Entites are connected by a series of relationships
       • built using common feilds
         • represented by entity relationship diagrams

3. Local databases

   • Local databases are used for one person, it is not connect to any database but itself, this allows no one to see you personal information let alone edit or delete it.

4. Network databases

   • Network databases are used at schools, business etc. they are used mostly for employees or pupils, the network is connected, allowing the employer or the teachers to see personal information however cannot edit it or delete it.

5. Online databases

   • Examples
     • Facebook
     • Tescos
     • Ebay
     • Amazon
   • They are used to store Information about different types of items and whether they are still in stock and it also stores users and their personal information.