{"id":69428,"date":"2021-08-20T14:23:05","date_gmt":"2021-08-20T18:23:05","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/tools-to-create-er-diagrams-from-a-database-dynamically-2\/"},"modified":"2021-08-20T14:23:05","modified_gmt":"2021-08-20T18:23:05","slug":"tools-to-create-er-diagrams-from-a-database-dynamically-2","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69428","title":{"rendered":"Tools to create ER diagrams from a database dynamically #2"},"content":{"rendered":"<pre>Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering option under Database menu helps to create ER diagram from existing database tables. Before that, target database drivers for visio need to be installed. If the database is in db2\/mysql\/postgresql, then  db2\/mysql\/postgresql drivers for visio should be installed. From Database\/options\/drivers, the driver needs to be configured. Afterwards, Reverse Engineering option may be used to create the ER diagram. There is no suitable driver for postgresql databases for Visio. ODBC drivers may be used for the purpose (the ER diagram may not be accurate from ODBC driver for postgresql). dbVisualizer:In dbVisualizer, when the TABLEs group\/option is selected in the left pane in the right\/middle pane there will be a references option. When the references tab is selected, an ER diagram is displayed using all tables. The ER diagram can be displayed as Hierarchical, circular, orthogonal, or organic. There are options for the purpose.When a single table name is selected, the table and the associated tables are displayed in an ER diagram.In the rightest column, selected tables option allows to create ER diagrams only for the selected tables. When 'selected tables' is clicked a list is displayed in a dialog box. Tables can be selected from this list (use control key). Build graph  option creates and displays the ER diagram.<\/pre>\n<p>From: http:\/\/sitestree.com\/?p=4785<br \/> Categories:2<br \/>Tags:<br \/> Post Data:2012-08-27 09:57:03<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering option under Database menu helps &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69428\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69428","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69428,"position":0},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24463,"url":"http:\/\/bangla.sitestree.com\/?p=24463","url_meta":{"origin":69428,"position":1},"title":"Java Spring: Components to Deal with Database (SQL Aspect) #Root","author":"Author-Check- Article-or-Video","date":"April 10, 2021","format":false,"excerpt":"Java Spring: Components to Deal with Database (SQL Aspect) JPA: Java Persistence API including spring-data-jpa, spring-orm and Hibernate JOOQ: Persistence support using Java Object Oriented Querying MyBatis: Persistence support using MyBatis JDBC: JDBC databases H2: H2 database (with embedded support) HSQLDB: HSQLDB database (with embedded support) Apache Derby: Apache Derby\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69412,"url":"http:\/\/bangla.sitestree.com\/?p=69412","url_meta":{"origin":69428,"position":2},"title":"Comparison: FireBird, MySQL, PostGreSQL #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.http:\/\/benchw.sourceforge.net\/benchw_results_open3.html Several PostGreSQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_postgres_history.html Several MySQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_mysql_indexes.html A good comparison among these databases will be found at:http:\/\/www.geocities.com\/mailsoftware42\/db\/ Mentionable comments PostGreSQL Supports 400+GB DB.One\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69245,"url":"http:\/\/bangla.sitestree.com\/?p=69245","url_meta":{"origin":69428,"position":3},"title":"Database Administration : Random #39","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"Vacuum:vacuum is a useful command to maintain PostGreSql database integrity. Also, it permanently removes deleted database records (by default PostGreSql does not delete permanently). It also rearranges page tables, segments for better performance. vacuum should be run regularly for optimized performance. You can also automate the execution. Syntax: vacuum [FULL|Analyze|Verbose|table\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78414,"url":"http:\/\/bangla.sitestree.com\/?p=78414","url_meta":{"origin":69428,"position":4},"title":"Differences among Functional Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams? Why are these important in OOD and OOP.","author":"Sayed","date":"August 27, 2025","format":false,"excerpt":"Got it \ud83d\udc4d I\u2019ll structure everything into a clear comparison table that\u2019s easy to read and copyright-free for posting on your FB\/blog. \ud83d\udcd8 OOD & OOP Diagrams \u2013 Quick Comparison Diagram TypePurpose \/ FocusStatic or DynamicExample UseFunctional DiagramShows system functions and how data flows between them.Static (overview level)Mapping out major\u2026","rel":"","context":"In &quot;Enterprise Architect&quot;","block_context":{"text":"Enterprise Architect","link":"http:\/\/bangla.sitestree.com\/?cat=98"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-22.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-22.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-22.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-22.png?resize=700%2C400 2x"},"classes":[]},{"id":68483,"url":"http:\/\/bangla.sitestree.com\/?p=68483","url_meta":{"origin":69428,"position":5},"title":"Access 2007: How to #90","author":"Author-Check- Article-or-Video","date":"August 4, 2021","format":false,"excerpt":"Access 2007: How toHow to compact and repair database?File menu (Alt+F) -> Manage -> Compact and Repair Database. Why? To reduce file\/database size. Helpful - when you want to upload to a remote server. Compacting and Repairing databases many times can solve many database issues. Use the feature once in\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69428"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69428\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69428"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}