Mapa mental
Types of Database Relationships
Conteúdo do mapa
Types of Database Relationships
One To One
- One record in the first table corresponds to just one record in a different table. An example of this would be patient to doctor, as one patient only has one doctor. It can be quite inefficient and is not good practise, as you have to link every single record.
One To Many
- One record in one table can have many links to data in a different table. An example is that one customer can have many orders. this is good practise as it is efficient and easy to implement.
Many To Many
- This is very hard to implement, so you would have to introduce another table to achieve one to many relationships instead. an example would be rental DVDs to customers.
Relationships
- Information is stored in sets of related tables based on the entites
- Relationships built through shared common fields
- Overcome the problems of storing everything in single tables
Entity Relationship Diagrams (ERDs)
- An ERD is a specialised graphic that shows the relationships between entities in a database
Informações
- Descrição
- Mapa Mental sobre Types of Database Relationships, criado por 11rtennyson em 18-11-2014.
- Criado por
- 11rtennyson
- Visualizações
- 6
- Avaliação
Mais sobre Database Keys and Relationships