Help shape GoConqr. What should we add next?

Mind map

Types of Relationships

11lharris English

Map content

Types of Relationships

  1. One to many

    • One record in one table will have links to many other tables
    • E.g. many orders can be linked to one customer in a database
  2. One to one

    • A one to one relationship is when one record in one table is linked to another record in another table
    • Can be quite inefficient because you have to have linked all the individual pieces of data together
    • E.g. in a hospital, patient details need to be stored and will be stored in ONE place
  3. Many to many

    • A many to many relationship is where there are multiple
    • E.g. multiple videos to multiple customers
    • Aren't often used as they can be very complex when used to sort lots of data
  4. Information is stored in sets of related tables based on the entities

  5. Relationships built through shared common fields

  6. Overcome the problem of storing everything in single tables

  7. Entity Relationship Diagram: an entity relationship diagram (ERDs) is a specialised graphic that shows the relationships between entities in a database

Information

Description
Mind Map on Types of Relationships, created by 11lharris on 18/11/2014.
Created by
11lharris
Views
11
Rating

More on Database Keys and Relationships

Feedback

What is it about?

What should we add next?