Mindmap
Relationships
Inhalt der Mindmap
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
Informationen
- Beschreibung
- A level IT Mindmap am Relationships, erstellt von Adam Riding am 23/03/2017.
- Erstellt von
- Adam Riding
- Aufrufe
- 0
- Bewertung
Mehr zu Database Keys and Relationships