Mind map
Types of Relationships
Map content
Types of Relationships
One-to-Many
- 1 record in one table will have many links to another table
- Example
- In business, one customer - many orders
- Efficient as easy to see and fewer records are linked individually
One-to-One
- 1 record in one table relates to just 1 record in another
- Example
- In a hospital, patient - medical record
- Inefficient as many records have to be linked
Many-to-Many
- Example
- In a rental company, many videos - many customers
- Many records in one table linking to many records in another
- Inefficient as very complex
- Usually broke down into One-to-Many tables
- Example
Information is stored in sets of related tables based on the entities
Relationships built through shared common fields
Overcomes the problems of storing everything in single tables
An entity relationship diagram (ERD) is a specialised graphic that shows relationships between entities in a database
Information
- Description
- Mind Map on Types of Relationships, created by 11cknight on 18/11/2014.
- Created by
- 11cknight
- Views
- 9
- Rating
More on Database Keys and Relationships