Types of relationships

Types of relationships

1. One-to-one

   • Patient details
   • One record is linked to one record in another table

2. One-to-many

   • One customer can have many orders
   • One record will have many links to another table

3. Many-to-many

   • More than one thing in a table is linked to more than one thing in another table
   • They are very rare

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

5. relationships is built through shared common fields

6. overcome the problems of storing everything in single tables

7. Entity relationship diagram (ERD) is a specified graphic that shows the relationships between entities in a database.