title: How to determine cardinality of foreign key using mysql
body: <p>I am stuck in a problem where i have to find cardinality of a relationship between tables using mysql. Following this post <br /> <a href="https://stackoverflow.com/questions/273794/mysql-how-to-determine-foreign-key-relationships-programmatically">MySQL: How to determine foreign key relationships programmatically?</a> <br />
  I have found all tables related to my table and the columns which are foreign key. Now i also want to find the cardinality of relationship i.e. one-to-one, one-to-many or many-to-many. Any ideas or snippets would be highly appreciated</p>