Mapa mental
Types of Relationships
Contenido del mapa
Types of Relationships
One to many
- One record in one table will have links to many other tables
- E.g. many orders can be linked to one customer in a database
One to one
- A one to one relationship is when one record in one table is linked to another record in another table
- Can be quite inefficient because you have to have linked all the individual pieces of data together
- E.g. in a hospital, patient details need to be stored and will be stored in ONE place
Many to many
- A many to many relationship is where there are multiple
- E.g. multiple videos to multiple customers
- Aren't often used as they can be very complex when used to sort lots of data
Information is stored in sets of related tables based on the entities
Relationships built through shared common fields
Overcome the problem of storing everything in single tables
Entity Relationship Diagram: an entity relationship diagram (ERDs) is a specialised graphic that shows the relationships between entities in a database
Información
- Descripción
- Mapa Mental sobre Types of Relationships, creado por 11lharris el 18/11/2014.
- Creado por
- 11lharris
- Visitas
- 11
- Valoración
Más sobre Database Keys and Relationships