Help shape GoConqr. What should we add next?

Mind map

Types of Database Relationships

11rtennyson English

Map content

Types of Database Relationships

  1. 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.
  2. 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.
  3. 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.
  4. 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
  5. Entity Relationship Diagrams (ERDs)

    • An ERD is a specialised graphic that shows the relationships between entities in a database

Information

Description
Mind Map on Types of Database Relationships, created by 11rtennyson on 18/11/2014.
Created by
11rtennyson
Views
6
Rating

More on Database Keys and Relationships

Feedback

What is it about?

What should we add next?