Types Of Relationships

Types Of Relationships

1. One to one

   • patients details
   • one record is linked to one record in another table

2. One to many

   • one record will have many links to another table
   • Customers orders

3. many to many

   • they are very rare
   • more than one thing in a table can link to more than one thing in another table

4. information is stored in sets of related tables based on the entities

5. relationships built through shared common fields

6. overcome the problems of storing everything in single tables

7. An entity relationship diagram is specialised graphic that shows the relationships between entities in a database