Mindmap
Relationships
Inhalt der Mindmap
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
Informationen
- Beschreibung
- A level IT Mindmap am Relationships, erstellt von Josh Woolley am 23/03/2017.
- Erstellt von
- Josh Woolley · Mär 2017
- Aktualisiert
- 10 Apr 2017
- Aufrufe
- 1
- Bewertung
Mehr zu Database Keys and Relationships