Types of Relationships

Types of Relationships

1. One to many

   • One record is linked to multiple other records in another table
   • EG: A customer renting/ buying many video tape

2. Many to many

   • More than one record in a table is to linked to many other records in another table
   • EG: Different videos sent to many customers

3. One to one

   • One record in one table is linked to another record which is only one of bit off a table
   • EG: A patient's detail in a hospital would be sent to one doctor.

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

5. Relationships built through shared common fields

6. An entity relationship diagram is a specialized graphic that shows the relationship between entities in a database.