MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Relationship One-to-Many (1:0) Mandatory/Optional
Posted by: Wladimir Coka
Date: August 28, 2009 12:51AM

Im still a little confused about how or when is used the optionlity.

Inserting a value in the referenced table requires to have this value also in referencing table. But how about the other way?

For example:

customer
Invoce

An Invoice NEEDs and customer but the customer MIGHT have invoces, should this be the case when the notation at invoice be Many (cardinality) and Optional? instead of the default (Mandatory)?

Thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Relationship One-to-Many (1:0) Mandatory/Optional
6850
Wladimir Coka
August 23, 2009 01:45PM
Re: Relationship One-to-Many (1:0) Mandatory/Optional
5859
Mike Lischke
August 25, 2009 01:29AM
Re: Relationship One-to-Many (1:0) Mandatory/Optional
4244
Wladimir Coka
August 28, 2009 12:51AM


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.