Gestalte GoConqr mit. Was sollen wir als Nächstes hinzufügen?

Mindmap

Types of Relationships

11lharris Englisch

Inhalt der Mindmap

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

Informationen

Beschreibung
Mindmap am Types of Relationships, erstellt von 11lharris am 18/11/2014.
Erstellt von
11lharris
Aufrufe
11
Bewertung

Mehr zu Database Keys and Relationships

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?