Log into the database as Schema Owner and:

SQL> select * from tab;
SQL> select * from cat;

Is this what you are looking for OR do you want to see it graphically (use a CASE tool to reverse engineer the schema).