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

Mapa mental

Types of Relationships

11jbennison Inglés

Contenido del mapa

Types of Relationships

  1. One to One

    • One record in one table relates to another record in another table
    • inefficient as a lot of records have to be linked
    • Patient will have one address and one appointment
  2. One to Many

    • One record in one table relates to many links in another table
    • A customer could have a lot of orders
    • The best one to choose as there will be less links than the one to one but not as complicated as many to many
  3. Many to Many

    • Introduce another table to change to one to many as it isn't efficient
    • Many videos to many customers
    • Many records in one table will link to many records in another
  4. Information is stored in sets of related tables based on the entities

  5. Relationships built through shared common fields

  6. Overcome the problems of storing everything in single tables

  7. An entity relationship diagram (ERD) 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 11jbennison el 18/11/2014.
Creado por
11jbennison
Visitas
10
Valoración

Más sobre Database Keys and Relationships

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué deberíamos añadir?