faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

21 of 26 people (81%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

Database: Microsoft SQL server:Enterprise manager: Table: Relationship: Diagram: How create diagram?

Jan 1st, 2004 18:13
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 24 December 2003 - 00:30 am -------------------
Database: Microsoft SQL server:Enterprise manager: Table: 
Relationship: Diagram: How create diagram?
---
Steps: Overview:
 1. -Start Microsoft SQL server 'Enterprise manager'
 2. -In the left pane click '+'
    of 'Microsoft SQL Servers'
 3. -click '+' of 'SQL Server Group'
 4. -click '+' of your server
     (e.g. (local) (Windows NT))
 5. -click '+' of 'Databases'
 6. -click '+' of your database
      e.g. select the 'Northwind database'
           on my computer here
 7. -right click on 'New' in the list
 8. -select from list 'Database Diagram...'
 9. -a dialog box 'Create Database Diagram Wizard'
     opens
10. -click button 'Next'
11. -In the left pane highlight the tables you want
     to view
12. -click button 'Add', when finished highlighting
13. -click button 'Next'
14. -click button 'Finish'
15. -You will now see an overview of your tables
16. -To zoom in or out to see the drawing better
     1. right click on the page
     2. -select from list 'Zoom'
     3. -Choose a number (e.g. 100%, 200%, ...)
17. -Possibly save this diagram
     1. -Click the 'floppy disk' icon
         in the menu tasbar
     2. -Supply a name for this diagram
         e.g.
          mydiagram1
     3. -click button 'OK'
---
---
Note:
You can thus quickly test here table relationships
and see how they look like graphically.
Create some simple examples
e.g.
first 1 table without keys, then 1 table with key,
then 2 tables without keys, then 2 tables with keys,
then 3 tables without keys, then 3 tables with keys,
and so on.
And or look at your already created database tables,
of which you know the structure good.
So by looking at a few examples, by induction (that is
generalizing this specific examples) you might get a clear
picture of how to analyze such diagrams better.
---
---
Internet: see also:
---
Database: Microsoft SQL server: Enterprise manager: Table: Diagram: 
Overview: Can you give overview?
http://www.faqts.com/knowledge_base/view.phtml/aid/27877/fid/147
---
[Internet: Book: Wrox: Beginning ASP.NET 1.1 with VB .NET 2003 - 
http://www.wrox.com/books/sample-chapters/samplechapter_0764557076.pdf]
----------------------------------------------------------------------