Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 data model by visio

Author  Topic 

js.reddy
Yak Posting Veteran

80 Posts

Posted - 2009-11-18 : 06:51:13
I am new to Visio,I have task to create database diagram using
Microsoft office Visio 2007. can any one please tell me the process how can create a data model by Visio from SQL server 2005 database.

Thanks in Advance

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-11-18 : 07:28:15
If you have Visio Professional, there's a Reverse Engineer feature that will build a diagram from your database. It's pretty self-explanatory.

Otherwise you'll have to create the diagram manually.
Go to Top of Page

melina386
Starting Member

7 Posts

Posted - 2009-12-09 : 23:21:05
A data model in software engineering is an abstract model that describes how data is represented and accessed. Data models formally define data elements and relationships among data elements for a domain of interest.

Data model explicitly determines the meaning of data, which in this case is known as structured data (as opposed to unstructured data, for example an image, a binary file or a natural language text, where the meaning has to be elaborated). Typical applications of data models include database models, design of information systems, and enabling exchange of data. Usually data models are specified in a data modeling language.[2].

A data model can be sometimes referred to as a data structure, especially in the context of programming languages. Data models are often complemented by function models, especially in the context of enterprise models.

http://e-datapro.net
Go to Top of Page
   

- Advertisement -