divadiva Posted December 4, 2008 Share Posted December 4, 2008 Experts, I am cretaing an entity relationship diagram for already existing website.I am having trouble in defining relationships. There are two tables : Inventory table and manufacturer table. Inventory tabel have manufacturer.Manufacturer has man_name. manufacturer in inventory is loaded frm php commands.Similarly, man_name is loaded in manufacturer. I was thinking relation should be Inventory*<----------* Manufacturer in ERD Please let me know if it is right. Thanks in advance. Link to comment https://forums.phpfreaks.com/topic/135499-solved-erd-in-mysql/ Share on other sites More sharing options...
Mchl Posted December 4, 2008 Share Posted December 4, 2008 So, `manufacturer` in `inventory` table references a record in `Manufacturer` table? I'd say the arrow goes from inventory to manufacturer. Link to comment https://forums.phpfreaks.com/topic/135499-solved-erd-in-mysql/#findComment-705903 Share on other sites More sharing options...
divadiva Posted December 4, 2008 Author Share Posted December 4, 2008 Thanks for replying. So what you just mentioned is that "manufacturer in inventory table will be a foreign key "? Link to comment https://forums.phpfreaks.com/topic/135499-solved-erd-in-mysql/#findComment-705908 Share on other sites More sharing options...
Mchl Posted December 4, 2008 Share Posted December 4, 2008 Yes Link to comment https://forums.phpfreaks.com/topic/135499-solved-erd-in-mysql/#findComment-705913 Share on other sites More sharing options...
divadiva Posted December 4, 2008 Author Share Posted December 4, 2008 Thankyou!! Link to comment https://forums.phpfreaks.com/topic/135499-solved-erd-in-mysql/#findComment-705915 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.