erd

What's a Good Database ERD Tool for Linux?

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. ...

Recommendations for good book and/or online documentation for Entity Relationship Diagrams

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 an exchange format for ERD ?

Is there a way to exchange ERD diagram from one tool to other as XMI exists for exchanging UML documents? ...

What GOOD tools are available for generating ERD from a SQL Server Database?

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. ...

Entity Relationship Diagram (ERD) program for Linux?

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. ...

Can you export packaging information (ERD or other data model) from Cognos 8.3?

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? ...

Create ERD type diagrams from Rails code

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. ...

What is the best ERD tool for forward-enginnering a SQL Server database?

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...

Interpreting an ERD

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...

In an ERD what makes an entity "optional" vs "required"?

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? ...

Does an ERD prescribe an implementation approach?

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 to draw ERD wih cardinality?

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 ...

How to make E-R diagram with 500 tables?

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...

Derby Entity Relationship Diagram

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 ...

SQL Server to er model

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? ...

Data Model tools for DB2

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? ...

Anyone have an ERD symbols quick reference?

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. ...

How to improve a ERD

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? ...

The right way in designing a database

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 ...

To get primary and foreign keys right in ERD

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...