Is there a way to get the cardinality between tables, from a MySQL database? I am working on a project where I have to analyze a MySQL database. I can find every relationship between tables in information_schema.tables, but I need to get the cardinality from each relationship. 


  In the relational model, tables can be related as any of "one-to-many"
  or "many-to-many". This is said to be the cardinality of a given table
  in relation to another.


Is there a way to get that information?
What I understood from your question is that you need to list all the parent and child relationship in your database, for that you can execute below query

SELECT 
    ke.referenced_table_name 'parent table',
    ke.referenced_column_name 'parent column',
    ke.table_name 'child table',
    ke.column_name 'child column',
    ke.constraint_name
FROM
    information_schema.KEY_COLUMN_USAGE ke
WHERE
    ke.referenced_table_name IS NOT NULL
        AND table_schema = 'your_db_name'
ORDER BY ke.referenced_table_name;


Here your_db_name is my database.