I've recently switched to Linux on my work machine and, new to the Linux desktop environment, I'd like to find a decent ERD tool for database design. Booting back into my Windows partition every time I need to create a diagram is going to get unpleasant quickly. I looked at Dia, but didn't see any DB tools - only UML, networking, etc. ...
Hi there, The wiki page on ERD has a lot of useful information, but I was wondering if you had any recommendations for good books and/or online documentation for a more in-depth description of ERD's? Thanks. ...
Is there a way to exchange ERD diagram from one tool to other as XMI exists for exchanging UML documents? ...
I am trying to generate an Entity Relationship Diagram from an existing MS SQLServer 2005 database. What tools are available? Specifically,I am not only interested in ERD's more directly I am looking for a tool to help quickly learning and analysing a medium size (schema wise not really row wise) database structure. ...
Any recommendations? Dia and Vym come to mind, but they don't really fulfill the main requirement; i.e. to generate the SQL to create the ERD that I'm describing. ...
Hey, I was wondering if there's a way to export package information from Cognos 8 from a regular user level or from the framework level. For instance, I want the field names that cognos is pointing to on the database, i want the datatype, the description cognos uses when you right click a data element, etc.. Any suggestions? ...
I'm beginning to learn Ruby on Rails, and looking at other peoples code. Is there any way to take an exisiting codebase and create object relationship diagrams or Entity relationship diagrams (ERD's) ? I know Visio can do some things given a database, but I was hoping to produce diagrams of classes, objects and objects. ...
My current understanding is that Microsoft does not offer a viable tool for creating a DB ERD model and then forward-engineering the DDL to create the database. I've heard that Visio Enterprise Edition 2003 had this feature, but that it has been removed in subsequent editions, and that the old edition does not operate well when installe...
What's the difference between the CategorySection-Category relationship and the CategorySection-Categorization relationship? CategorySection-Category has an arrowhead and a black dot. CategorySection-Categorization has an arrowhead on both ends. Both are supposed to be "has many" relationships but this diagram uses a different symbol...
As I understand it, the white dot indicates "optional" while the black dot means "required". If so, a Category is required while a Classified is optional. But what does that actually mean in the database - to say that a Category is required and a Classified is optional? ...
One of the things that confuses me about ERDs is whether they make any prescriptions about how their relationships should be implemented technologically. In the diagram below I'm not sure if the diagram requires these relationships to be implemented at the database level or at the application level. Is it making any technological presc...
how do I draw a ERD with cardinality? I am still in school and I am not sure how to go about it. I just need a sample idea Thanks ...
In our company we have a huge project with lots of tables. When I mean a lot it is about 500. Maybe it is something normal. Some of these tables have more than 200 fields. I find that trying to make an E-R Diagram for the whole system will be confusing, tiring and useless. Just including the tables would result in a frightening list of b...
Is there any free software out there for extracting the diagram of my derby database? (Like MySQL Workbench for MySQL?) Or maybe a plugin for netbeans? Thank you ...
Is there a program that converts a SQL Server database diagram to er model, or create er model of a database from SQL Server server? ...
I have created a Database in DB2 and tables with relationships. I would like to create a ER diagram based on my database design in DB2. MS SQL has a facility to create ER diagrams from DB schema, but DB2 doesn't seem to have one, at least to my knowledge. Any one know of any open source tools/facility within DB2 itself for this? ...
I'm looking for a one-page quick-reference or cheatsheet (preferably in PDF) to the meanings of the various ERD symbols in Crowsfoot/Martin notation. I've done a lot of googling, but have not found a good, concise quick-reference guide, though I'm sure one must exist. ...
This question is based on my plan at the thread. My entity-relationship diagram is I would like to know the following. Does my sequence diagram match the following relation diagram? ...
I started my first MySQL project designing the ERD, logical and physical diagrams. A friend of mine is making the same project as me. I started the plan of my databases by making an ERD and then normalizing. However, he uses a relational database diagrams where he designs interfaces and other parts first before making the ERD. He for ...
I read my notes and I am now unsure about the keys. My logical diagram This table should be in line with the following physical ERD I have only one foreign key in the table Question. I would like to know should the question-id and question-tag in the table Question-tag-xref, AND question-id and answer in the table Answers be a...