Table relation analysis assisting apparatus and table relation analysis assisting method

A table relation analysis assisting apparatus analyzing a relation between pieces of data in a certain column astride tables in a relational database, comprising:

• inter-table relation analysis information in which tables the data of which is a one to one relation or a plural to one relation are defined as one table group;
• a one to one relation folding unit that outputs the inter-table relation analysis information obtained by consolidating tables in a one to one relation from inter-table relation information into a table group;
• a plural to one relation folding unit that consolidates tables in a plural to one relation into a table group and thereby updating the inter-table relation analysis information;
• and
• an analysis result display unit that displays details of the inter-table relation analysis information,
• wherein the analysis result display unit provides a display in such a form that one or more tables in a relational database are contracted into a table group.