Cardinality

21 Views

Hi,

From F4 help i got the following:

Cardinality of a relationship

The cardinality (n : m) describes the foreign key relationship with regard to the number of possible dependent records involved (records of the foreign key table) or referred records (records of the check table).

The right side of the cardinality has the following significance:

m = 1

For each record of the check table there is exactly one dependent record.

m = C

For each record of the check table there is at most one dependent record.

m = N

For each record of the check table there is at least one dependent record.

m = CN

For each record of the check table there are any number of dependent records.

I am not able to understand the above description. Specially what is dependent records. Can any one make me understand what is cardinality if possible with example.

Thanks in advance.

abhishek