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

Mindmap

Types of Relationships

11cknight Englisch

Inhalt der Mindmap

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

Informationen

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

Mehr zu Database Keys and Relationships

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?