Hi guys i want to make fleet management program to cars in my organization but in erd diagram i face problem I have two table
Driver table
Diver No
Name
Address
Car No
Car table
Car No
Driver No
I want to make design many to many relationship means one car can driven by many drivers and one driver can drive more cars.
My question how i represent this relation in database and interface (meaning are i make table to driver and table to car only in case that relation is many t many or what i do )
Loading
ahmed saPosted Jan 25, 2014, 2:53 AM
ahmed saPosted Jan 22, 2014, 8:46 AM
ahmed saPosted Jan 22, 2014, 8:44 AM
Jignesh TrivediPosted Jan 22, 2014, 7:25 AM
hi,
Many to many relation between entities or table can be acheive by introducing the one table
Like
Driver table
Diver No
Name
Address
Car table
Car No
DriverCarMapping Table
CarNo
DriverNo
hope this will help you.
Deepak VermaPosted Jan 22, 2014, 7:03 AM
I think, it's a good idea to keep DriverNo and CarNo columns Primary Key in Driver Table and Car Table respectively. And create a third table with columns DriverNo and CarNo (both as Foreign Key).