Ajude a dar forma ao GoConqr. O que a gente deve adicionar?

Mapa mental

Types of Relationships

11lharris Inglês

Conteúdo do mapa

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

Informações

Descrição
Mapa Mental sobre Types of Relationships, criado por 11lharris em 18-11-2014.
Criado por
11lharris
Visualizações
11
Avaliação

Mais sobre Database Keys and Relationships

Fale Conosco

Sobre o que é sua mensagem?

O que a gente deve adicionar?