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]

----------------------------------------------------------------------