Mind map
Relationships
Map content
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
Information
- Description
- A level IT Mind Map on Relationships, created by Adam Riding on 23/03/2017.
- Created by
- Adam Riding
- Views
- 0
- Rating
More on Database Keys and Relationships