Mind map
Relationships
Map content
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
Information
- Description
- A level IT Mind Map on Relationships, created by Josh Woolley on 23/03/2017.
- Created by
- Josh Woolley · Mar 2017
- Updated
- Apr 10, 2017
- Views
- 1
- Rating
More on Database Keys and Relationships