How to construct ER diagrams ?

Question

0.00/5 (No votes)

See more:

Hello everyone,

I am developing a project and diving into database very simpler. For example I am inserting updating and deleting data via buttons. That is success for me.

Actually I want to construct a little bit more complex project. When I searched I have seen that I need ER diagrams, primary keys, foreign keys etc.

Could anyone give some information about this ?

Posted 12-Aug-12 21:13pm

FoxRoot

Add a Solution

2 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)

**JF2015** · Accepted Answer · 2012-08-12T21:19:00

Solution 1

A good starting point to find more information about ER Diagrams is as always the Wikepedia:
http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model[^]
To create such diagrams, I would recommend you to use Microsoft Visio.
http://www.sethi.org/classes/cet415/lab_notes/lab_03.html[^]

Posted 12-Aug-12 21:19pm

JF2015

Comments

FoxRoot 13-Aug-12 3:24am

Thanks but I have problems about table manner. For example in my project I have courses and instrutctors. I will assign more than 1 courses to 1 instructor. sometimes I will need to represent some special tables such as courses which has over 50% success rate and etc.

Namely I have very big problems with this.

Sant Osha · Accepted Answer · 2012-08-12T21:23:00

Solution 2

Create all tables required for your project, create primary key and give relationship.After all this, click on Databse diagram, click to add tables and then you have ER Diagram.

Posted 12-Aug-12 21:23pm

Sant Osha

Comments

FoxRoot 13-Aug-12 3:26am

Is it simple like that? I have created the java forms. How could I create tables ?