MySQL Forums
Forum List  »  MySQL Workbench

one to one relationship
Posted by: Pete Watters
Date: October 01, 2017 12:54PM

one to one relationship

Table 1 parent Table 2 child

Does this mean there can only be one row in both tables that connect to each other

If table1 has 100 rows than table 2 has 100 rows?

If its a identifying relationship than if there is a child there must be a parent row?

If its non-indetifying can there be a child row without a coresponding parent row?

There can be a 100 rows in the parent table buy there can be a 100+ rows in the child table

Am I correct

Options: ReplyQuote

Written By
one to one relationship
October 01, 2017 12:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.