Cardinality Attribute

Cardinality defines the numeric relationships between occurrences of the tables on either end of the relationship line. In other words, cardinality refers to the number of rows in the table at each end of the relationship line. There is typically a parent-child relationship between tables. In the previous figure, the relationship line between the CONSTITUENT and USR_WIDGET tables contains a key and an infinity symbol. These symbols denote that for every 1 constituent (key symbol), there are many (infinity symbol) widgets in the database. There is a one-to-many relationship between constituents and widgets. Another way to put it is to say that a parent CONSTITUENT row can have many related children USR_WIDGET rows.

In the Infinity platform, the Cardinality attribute indicates the cardinality of the relationship between the two tables in the relationship. The two options are ManyToOne and OneToOne. Select ManyToOne to indicate that a constituent can have many widgets. Select OneToOne to indicate that a constituent can only have one widget. The Cardinality attribute is optional and has as a default value of ManyToOne.

Wikipedia article: Cardinality (data modeling)