Showing relationship among database tables

• SchemaSpy software is used for showing relationship among different tables. It is free software.

• SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
• SchemaSpy uses the dot executable from Graphviz to generate graphical representations of the table/view relationships.
• Install Graphviz by running following command:

sudo apt-get install graphviz

• SchemaSpy uses JDBC’s database metadata extraction services to gather the majority of its information.
• Run following commands to install java :

  apt-cache search jdk

  sudo apt-get install openjdk-7-jdk openjdk-7-jre

• Download the SchemaSpy Software from following link “http://sourceforge.net/projects/schemaspy/files/schemaspy/SchemaSpy%205”
• Run the following commands:

 cd Download

mv SchemaSpy_5.0.0.jar SchemaSpy.jar

• Run SchemaSpy from the command line:

java -jar schemaSpy.jar -t mysql -o library -host localhost -db library -u user -p password -dp /usr/share/java/mysql-connector-java.jar

• Give username and password and database name which have you want to gernate the dfd.
• After this library Directory is gernate automatically and in this index.html file is gernate.
• Open this index.html in browser and see output on your Browser.