Re: Implementing relationship with the EER

[jean-marc fournier]

Hi Peter,

so I have implemented in Workbench something like this:

table 'people':
- id
- firstname
- lastname
- country
- age

table 'cars':
- id
- modelname
- year
- color
- powerinhp

table 'vendors':
- id
- name
- country

Now i have generated in Workbench an 'n:m' relation between people and cars and another one between cars and vendors.

Workbench has created 2 bridge tables and has connected them ('people_has_cars' and 'cars_has_vendors') with 2 primary keys:

('people_id' and 'cars_id') and ('cars_id' and 'vendors_id') in the respective table.

Do i have to add anything to the bridge tables?

How shall I fill the bridge tables so that the people are in relation with their car(s) and the cars with their vendor?

Thank you for your support.

JM