Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I detect relationships that are not defined using the Foreign Key mechanism?

April 26, 2017defined detect foreign key mechanism Relationships

0

Posted

Can I detect relationships that are not defined using the Foreign Key mechanism?

1 Answer

0

Posted

Yes. Examiner will infer implied relationships if requested, based on same name attributes. For example, if in table CLIENT there is a PK based on column Cli_ID and in the ORDERS table there is a non-key column attribute Cli_ID, Examiner will detect this relationships as being a one-to-many (1:N) from CLIENT to ORDERS. It is a 1:N because on the CLIENT side the column is unique (it is a PK) and on the ORDERS side the column in non-unique (non-key attribute).