want to know how to convert ms sql database to relational model?

Question

1.00/5 (1 vote)

See more:

i have created database in Microsoft sql server & i want to convert that db to a relational model. is there any software's to convert sql query, or sql database to relational model(mapping) ? please help me

Posted 24-Sep-12 6:05am

supercomputer001

Updated 24-Sep-12 6:10am

v2

Add a Solution

1 solution

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)

Mehdi Gholam · Accepted Answer · 2012-09-24T06:19:00

Solution 1

Microsoft SQL Server is a relational database, when you create tables and relations you are creating a "relational model" for your data.

EDIT :
If you want to see the database diagram read this : http://www.mssqltips.com/sqlservertip/1816/getting-started-with-sql-server-database-diagrams/[^]

Posted 24-Sep-12 6:19am

Mehdi Gholam

Updated 24-Sep-12 8:14am

v2

Comments

supercomputer001 24-Sep-12 12:51pm

yes. i want to create a diagram including tables and their relationships(mapping) from a already created database

fjdiewornncalwe 24-Sep-12 13:30pm

Then you need to fix your terminology. What you want is a Diagram of your database, not a relational model. A relational model is the structure with which the tables are built. A diagram is is just that, a diagram of the existing relational structure.

Sergey Alexandrovich Kryukov 24-Sep-12 17:09pm

Exactly. But to be 100% fair, it's well known that SQL is not perfectly relational.
--SA

supercomputer001 24-Sep-12 14:05pm

yes. i want the database diagram

Mehdi Gholam 24-Sep-12 14:14pm

See the updated solution.

Maciej Los 24-Sep-12 16:23pm

Short and to the point! My 5!

Mehdi Gholam 24-Sep-12 16:33pm

Thanks Maciej!

Sergey Alexandrovich Kryukov 24-Sep-12 17:09pm

With the "EDIT" part, it makes my 5.
--SA

Mehdi Gholam 24-Sep-12 17:12pm

Thanks Sergey!