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. Quote Link to comment 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. Quote Link to comment 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 "? Quote Link to comment Share on other sites More sharing options...
Mchl Posted December 4, 2008 Share Posted December 4, 2008 Yes Quote Link to comment Share on other sites More sharing options...
divadiva Posted December 4, 2008 Author Share Posted December 4, 2008 Thankyou!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.