I have created a few tables in a database. But how do I cardinality between the tables.For example like 1:N,M:M or 1:N,M:O. is there a code for to declare them in the tables.
nope...its done by means of bridge tables ie tables having reference fields from parent tables. you can mark nature of relationship using data modelling tools
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
thats what I told. its a concept. the implementation is done by creating a bridge table having id fields from master table as foreign key references. The nature of relationship is specified in database model diagrams created using data modelling tools
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Cardinality
Posted - 09/24/2012 : 01:49:57
