Mapa mental
Relationships
Contenido del mapa
Relationships
Type
- 1:1
- E.g Employees: Cars
- Excess tables
- E.g Employees: Cars
- 1:Many
- E.g. Customer:Sales
- Many:Many
- E.g. Sales:Products
- Middle table
- Data application
- E.g. Sales:Products
- 1:1
Reasons
- Shows links between tables and data
- Allows queries to use multiple tables
Advantages
- Tells DBM's how to find data
- Allows complex queries
- Reduces data duplication
Disadvantages
- Takes more time to create
- More complex
- Hard to alter later
- Query errors
- More complex
- very complex queries can be slow
- Takes more time to create
Información
- Descripción
- A level IT Mapa Mental sobre Relationships, creado por Adam Riding el 23/03/2017.
- Creado por
- Adam Riding
- Visitas
- 0
- Valoración
Más sobre Database Keys and Relationships