Super User
Super User

Questions tagged [erd]

15 questions
10
votes
5 answers

Tool for automatically generating and laying out an entity relationship diagram?

I've seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven't been able to find one which is capable of automatically laying out the diagram in a reasonable way. Most of them just plop all the entities down on…
user18352
  • 223
3
votes
2 answers

How can I create a mandatory, non-identifying relationship between two entities?

I'm working in MS Visio 2010. This is the relevant part of my ERD: The relationship between Event and Adventure is correct: there's a foreign key from Event to Adventure, and that FK is part of Event's primary key. However, what I can't figure out…
Cam Jackson
  • 2,586
3
votes
1 answer

How do I give a column separate physical and conceptual names?

In Visio 2010, after creating an Entity using the Entity Relationship (Metric) stencil, I can choose to show Conceptual names, Physical names or Both in the Database Document Options dialog. If I choose Both, I can see two different names for each…
Air
  • 204
2
votes
0 answers

Create view based on table in MS VISIO 2003

I'm working on a physical ERD in Microsoft Visio 2003, and I want to create some views based on only one table. Right now I've having to manually add all the columns from parent table. Is there a way to base the view on the table, or perhaps drag…
C. Ross
  • 6,734
2
votes
1 answer

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I would like this so I can understand the DB better.
user206168
  • 456
2
votes
1 answer

How to create double outlined shape in Visio 2010?

Is there any way to create a double outlined shape (triangle) for example ? (i've noticed i can create another similar shape in the back but i'm looking for more elegant solution) Thanks
SagiLow
  • 187
2
votes
0 answers

DaRT 7.0 doesn't see my Windows installation

I created bootable CD for Microsoft DaRT 7.0. And when I boot, it doesn't see my Windows 7 32bit Ultimate installation. What can I do?
Someone
  • 239
2
votes
2 answers

How can I create an ERD for my phpmyadmin database?

Is there a way I can create an Entity Relationship Diagram for my PHPMyAdmin database?
raym0nd
  • 141
2
votes
2 answers

Specifying Multiplicity in a Visio Database (ERD) Diagram

Is there a way to manually edit the cardinality/multiplicity symbols on the end of a database ERD made in Visio? The category I'm using is in Visio 2003 under Database -> Database Model Diagram I want to be able to go from something like this: To…
Nitrodist
  • 1,638
1
vote
1 answer

What is u:R d:R that appears on ERD when adding relationship (Visio 2010)

I am building a Entity-Relationship diagram in Vision 2010 using crow's feet. Everytime I connect to tables with a relationship the following element appears near the "many" side. u:R d:R I can click on the element and delete it but would like to…
Christie
  • 11
1
vote
0 answers

Display primary : foreign key relationships in Visio database diagram

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the diagram. The only workaround I can find is to…
hurleystylee
  • 119
1
vote
1 answer

Visio ERD cannot fit in A4

I did a reverse engineering on a Oracle database into Visio 2010, the issue is that I can't find anywhere to make the size of the entities to fit into an A4 format, entities won't shrink. Am I missing something?
David Garcia
  • 129
1
vote
0 answers

Where is "erd" and "dot" program?

I have problem in vscode ERD diagram preview. (As seen above print-screen my VSCode) Have tried: https://marketplace.visualstudio.com/items?itemName=kaishuu0123.vscode-erd-preview#configuration What is the meaning: Make sure the extension can find…
parmer_110
  • 111
0
votes
2 answers

Restore Bootloader in Windows XP using ERD Commander

I need to restore a boot loader on my laptop. The problem is that Recovery utility from Windows XP install CD ask for Administrator password. I changed my Administrator password using ERD Commander. But it doesn't help me. I don't know why. My…
Peter Shipilo
  • 103
0
votes
1 answer

Need recommendations for free ERD software

Need to build some ERD's, what good/lightweight/free software would you recommend that can make building ERD's easier?
roman m
  • 1,079