Mindmap
Types of Relationships
Inhalt der Mindmap
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
Informationen
- Beschreibung
- Mindmap am Types of Relationships, erstellt von 11cknight am 18/11/2014.
- Erstellt von
- 11cknight
- Aufrufe
- 9
- Bewertung
Mehr zu Database Keys and Relationships