Rate this Article
Click on one of the stars below to rate this article from 1 (lowest) to 5 (highest).
One Moment Please
Thanks for rating this article.
Good easy to follow example for someone like me just starting/learning.
It appears the instructions above for 14 creating the entity Bus are incorrect
(should be- vehicle_id not id).
Also 15 (should be- Finally, create entity Driver from Bus, with an one-to-one relationship. Create the following columns in Driver.)
15. A bus is driven by a bus driver. Finally, create entity from Bus with a one-to-one relationship.
Create an entity Bus from Schedule, with an one-to-one relationship. Create the following
columns in Bus:
Using this sample, can you tell me how I would show which tables contribute to a view. I've created a view entity but I'd like to show which tables make up the view visually but don't see a way to do that. Thanks in advance.
this is very easy to understand who is initially learners for E-R diaghrams
Hi Richard and Bartek,
Thank you for pointing out the mistakes. All issues are now fixed.
excellent tutorial for basic learners of E-R diagram in visual paradigm
The way of explanation is good,
and easy to follow for a beginner like me.
Excellent tool for generating ERDs, I'm sure my students will make great use of this tool.
In the entity diagram J have a primary key, and J wanna to have a secundary key in a new column, how to do that?
Sorry about my english.
hhhh in the relationship specification we can mark the colum from some entity with the foreign key (at school we caled it secundary key, it is more logicaly :) and at the screen he apear with the green arrow !
Is it also possible to show user types in the diagram?
I can't find any setting to realize that.
You can show the user type defined in column specification window. Please try this:
1. Right click on the background of diagram
2. Select "Presentation Options > Entity Columns Display Options > Show Column User Type" from the popup menu.
Does anyone know how to implement "IS-A" in ERD using VP?
how to create one-to-one optional in ERD through uml pairadigm
You can set the cardinality via the specification of a relationship. Try this: Create a one-to-one. Right click on the connector and select Open Specification... from the popup menu. In the specification window, select "Zero or One" as the Cardinality of the to-side.
I am asking again & again how to create database for .net & mysql because everywhere u r creating database for java because i am not getting what is to be select in adapter & driver place when i am going through tools then database configuration (after creating ER Diagram) & i sent alot of mails regarding this but no body didnt reply for this & same for how to create class diagram using ER diagram.
You can simply press the Green Arrow button next to the Driver file and Adapter file field to let VP download the files for you. Please make sure you have run the application with Admin permission (right click on the executable and select Run as administrator), and also with proper proxy server setting specified (if you need proxy for access Internet).
BTW, we seems only receive 2 email request from you. As I know our support team are checking with you about your other requests. Feel free to contact us for any questions.
I have a question:
Now think about a University in terms of an ERD. What entities, relationships and attributes might you consider.
Thanks for your support.
Thank you for your post. I am afraid there is no definite answer because it depends on the system you are going to develop. Could you tell me more about your case?
I regret that we do not help our clients finish their works. But if you have any questions when you are drawing your ERD, you can ask and we will try our best to help.
nice example thanks for this i have an idea for my project :D
this system is actually amazing. does fleet_id in bus and id in driver are the same? if not could you please explain me the difference between the two? also kindly let me know what is last_main in bus? as i'm a beginner, I couldn't understand few concepts fully. thanks in advance
Hi PL Sivakami,
fleet_id in bus and id in driver are different. Let's say if a bus belong to a fleet called "Dragon", then it may have "DRG" as its fleet ID. id of driver is for uniquely identifying every single driver in the bus company. last_main stands for the last maintenance date. As you can see, it's in "date" type because its value is supposed to be a date.
I have a dfd and that im in a big confusion that how do i change that dfd to an er diagram can any one help me out
Thanks in advance
How Can I create SuperType and SubType in ERD?
It's suppose to become an abstract class in the class diagram (in UML diagram).
Thanks in advanced,