Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Karl DeSaulniers
On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl Foreign key is a good option (provided you use InnoDB database) to automate the deletion/updation of cart details when you remove cart. Besides 1:1 cardinality is good or bad can only be decided on the semantics of your tables.

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Amit Tandon
regds amit The difference between fiction and reality? Fiction has to make sense. On Mon, Dec 26, 2011 at 1:55 PM, Karl DeSaulniers k...@designdrumm.comwrote: On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl Foreign key is a good option (provided you use InnoDB

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Karl DeSaulniers
On Dec 26, 2011, at 3:05 AM, Amit Tandon wrote: regds amit The difference between fiction and reality? Fiction has to make sense. On Mon, Dec 26, 2011 at 1:55 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Amit Tandon
Dear KarlRefer Wiki entryhttp://en.wikipedia.org/wiki/Entity-relationship_model. The last diagram shows one to many relationship in many ways. That may help you in clearing your doubts about the comma which is a way of representing the relationship Quoted from MS Access example One-To-Many

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Karl DeSaulniers
Thank you! On Dec 26, 2011, at 4:12 AM, Amit Tandon wrote: Dear Karl Refer Wiki entry. The last diagram shows one to many relationship in many ways. That may help you in clearing your doubts about the comma which is a way of representing the relationship Quoted from MS Access example