topic foreign key-relationships in Transportation Questions https://community.esri.com/t5/transportation-questions/foreign-key-relationships/m-p/762406#M2514 <HTML><HEAD></HEAD><BODY><SPAN>Don't all origin tables have to have a foreign key to make a connection to another table?</SPAN><BR /><BR /><SPAN>In the book: Designing Geodatabases For Transportation by J. Allison Butler on page 18, Figure 2.3, if the Employee Table is the origin table and the Position Table is the destination table, how is it a (1:m) relationship?&nbsp; Shouldn't it rather be a (m:1) relationship?</SPAN><BR /><BR /><SPAN>What is meant by:&nbsp; The upper bound in the multiplicity determines the cardinality (pg 20 2nd paragraph)?</SPAN><BR /><BR /><SPAN>DG</SPAN></BODY></HTML> Sat, 26 Mar 2011 00:41:23 GMT DarrelGordon 2011-03-26T00:41:23Z foreign key-relationships https://community.esri.com/t5/transportation-questions/foreign-key-relationships/m-p/762406#M2514 <HTML><HEAD></HEAD><BODY><SPAN>Don't all origin tables have to have a foreign key to make a connection to another table?</SPAN><BR /><BR /><SPAN>In the book: Designing Geodatabases For Transportation by J. Allison Butler on page 18, Figure 2.3, if the Employee Table is the origin table and the Position Table is the destination table, how is it a (1:m) relationship?&nbsp; Shouldn't it rather be a (m:1) relationship?</SPAN><BR /><BR /><SPAN>What is meant by:&nbsp; The upper bound in the multiplicity determines the cardinality (pg 20 2nd paragraph)?</SPAN><BR /><BR /><SPAN>DG</SPAN></BODY></HTML> Sat, 26 Mar 2011 00:41:23 GMT https://community.esri.com/t5/transportation-questions/foreign-key-relationships/m-p/762406#M2514 DarrelGordon 2011-03-26T00:41:23Z