Help shape GoConqr. What should we add next?

Mind map

Types of Relationships

11cknight English

Map content

Types of Relationships

  1. One-to-Many

    • 1 record in one table will have many links to another table
    • Example
      • In business, one customer - many orders
    • Efficient as easy to see and fewer records are linked individually
  2. One-to-One

    • 1 record in one table relates to just 1 record in another
    • Example
      • In a hospital, patient - medical record
    • Inefficient as many records have to be linked
  3. Many-to-Many

    • Example
      • In a rental company, many videos - many customers
    • Many records in one table linking to many records in another
    • Inefficient as very complex
    • Usually broke down into One-to-Many tables
  4. Information is stored in sets of related tables based on the entities

  5. Relationships built through shared common fields

  6. Overcomes the problems of storing everything in single tables

  7. An entity relationship diagram (ERD) is a specialised graphic that shows relationships between entities in a database

Information

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

More on Database Keys and Relationships

Feedback

What is it about?

What should we add next?