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

Mapa mental

Types of Database Relationships

11rtennyson Inglés

Contenido del mapa

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

Información

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

Más sobre Database Keys and Relationships

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué deberíamos añadir?