Relationship – data models

One to many – one record in ‘Orders’ table have many records in ‘OrderLines’ table

One to One – one record in ‘Customers’ table have only one record in ‘CustomerProfile’ table

Many to Many – Many ‘books’ of the same copy can be barrowed by many people from a ‘library’

 

Relationship – data models

One to many – one record in ‘Orders’ table have many records in ‘OrderLines’ table

One to One – one record in ‘Customers’ table have only one record in ‘CustomerProfile’ table

Many to Many – Many ‘books’ of the same copy can be barrowed by many people from a ‘library’