Ayúdanos a dar forma a GoConqr. ¿Qué deberíamos añadir?

Mapa mental

Types of Relationships

11lharris Inglés

Contenido del 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

Información

Descripción
Mapa Mental sobre Types of Relationships, creado por 11lharris el 18/11/2014.
Creado por
11lharris
Visitas
11
Valoración

Más sobre Database Keys and Relationships

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué deberíamos añadir?