Mapa mental
Relationships
Conteúdo do 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
Informações
- Descrição
- A level IT Mapa Mental sobre Relationships, criado por Adam Riding em 23-03-2017.
- Criado por
- Adam Riding
- Visualizações
- 0
- Avaliação
Mais sobre Database Keys and Relationships