what are steps to make entity relationship diagram ?

Question

1.00/5 (1 vote)

See more:

what are steps to make entity relationship diagram ?

it,s very difficult to me create entity relationship diagraṃ erd and i know that there are steps to make it . so please help me to know it .

Posted 16-Apr-11 13:52pm

mostafa sabet

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2011-04-16T15:56:00

If you asked "I want to make entity-relationship diagram using this or that software tool", you could ask for some steps. But how can you say "there are steps to make it" it this is a while modeling method? No.

Learn about the method starting from its ideas (or rather starting from understanding relational model); and you will know the "steps", see http://en.wikipedia.org/wiki/Entity-relationship_diagram[^], http://en.wikipedia.org/wiki/Relational_model[^].

—SA

Jan Bakker · Answer 2 · 2014-10-11T05:41:00

Right click your solution.
Add -> new Folder
Name the new folder "Database"
Right click the new folder.
add -> New Item
Choose: Data -> ADO.NET Entity data model.
Give the model a name.
Choose: emty EF designer model
finish

Right click in the new window (model.edmx)
Add new -> entity (this will be a table in the database)
Give it a name (person)
Right click the new entity
add new -> Scalar property
give it a name (personLastName)
In visual studio properties windows you can make changes to this new property
Type, nullable ....

Make a new Entity
Name it Address
add some Scalar properties. (street name, city ....)

Now for connecting the two entities:
Right click the address entity.
Add new -> Association
(We will presume a person can none or multiple addresses, but a address must/can have only one person)

entity address:
Multiplicity *many
navigation property person

entity person
Multiplicity 0..1 (zero or one)
navigation property addresses (you have to change the text from address yourself)

Click: add foreign key properties to .....

If you read the text below all this, it clearly states what you are creating, this helps allot.

If you are ready, right click in the window (model.edmx) and click Generate database from model.
Follow the steps, and create your database with the newly created sql file.

Good luck.

Shanaka Dassanayake · Answer 3 · 2014-10-10T05:18:00

1. Identify data objects (entities) about which the system needs to store data.
2. For each entity, list its attributes and check the attributes for completeness. Mark the PK and FK, if any
3. Draw a line to show relationship and label it using a verb
4. Add relationship type (1-1, 1-many, many-many)
5. Add the participation constraint (optional or mandatory) to the relationship shown

what are steps to make entity relationship diagram ?

3 solutions

Solution 1

Solution 6

Solution 5

Add your solution here

Preview 0