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

Mindmap

Types of Database Relationships

11rtennyson Englisch

Inhalt der Mindmap

Types of Database Relationships

  1. One To One

    • One record in the first table corresponds to just one record in a different table. An example of this would be patient to doctor, as one patient only has one doctor. It can be quite inefficient and is not good practise, as you have to link every single record.
  2. One To Many

    • One record in one table can have many links to data in a different table. An example is that one customer can have many orders. this is good practise as it is efficient and easy to implement.
  3. Many To Many

    • This is very hard to implement, so you would have to introduce another table to achieve one to many relationships instead. an example would be rental DVDs to customers.
  4. Relationships

    • Information is stored in sets of related tables based on the entites
    • Relationships built through shared common fields
    • Overcome the problems of storing everything in single tables
  5. Entity Relationship Diagrams (ERDs)

    • An ERD is a specialised graphic that shows the relationships between entities in a database

Informationen

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

Mehr zu Database Keys and Relationships

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?