Mapa mental
Relationships
Contenido del mapa
Relationships
Type
- 1:1
- Employees:cars
- Excess tables
- Employees:cars
- 1:Many
- Customer:sales
- Many:Many
- Sales:products
- Data Duplication
- Middle tables
- Sales:products
- 1:1
Reasons
- Shows link between multiple tables & data
- Allows queries to use multiple tables
Advantages
- Tells DBMS how to find data
- Allows complex queries
- Reduces data duplication
Disadvantages
- More complex
- Query error
- Takes more time to create
- Many complex queries can be slow
- More complex
Información
- Descripción
- A level IT Mapa Mental sobre Relationships, creado por Josh Woolley el 23/03/2017.
- Creado por
- Josh Woolley · mar 2017
- Actualizado
- 10 abr 2017
- Visitas
- 1
- Valoración
Más sobre Database Keys and Relationships