topic Re: Reg : database tables in Application Development and Automation Discussions

Reg : database tables

Former Member — Wed, 13 Jun 2007 10:16:57 GMT

Hi experts,

How to know to find relationship between two dababase tables is one to one ,one to many, many to many...

thnaks ,

Ramesh

sreeramkumar_madisetty — Wed, 13 Jun 2007 10:18:11 GMT

check for <b>Cardinality</b>.

Regards,

Sree

Former Member — Wed, 13 Jun 2007 10:19:18 GMT

There is no such hardcode rule to find the relation

Based on the application module knowledge

you will come to know.

For example For one record in header table there will be mulitple records in Item table

So linking tables with proper keys is very important in programming

that will come with practice and experience

Reward points for useful Answers

Regards

Anji