Database Diagrams : Showing Relations Column to Column

Hi to all,

As I am going to deal with a huge number of database tables, I thought that drawing their diagrams will be the most professional way of keeping track of what I am doing. So In Enterprise Manager using the Wizard I made it to be drawn nicely.

But I have a problem now. I see that the relations defined among the tables are represented correctly but the line connecting the two table is drawn randomly. I mean the starting point of the line doesnt start from the column having the primary key and doesnt end near to the column having the foreign key. Viewing my diagram I want to see the lines to start and end showing the 2 related key columns.

Is there a way to accomplish this like setting an option, clicking somewhere or should I try to drag the lines to manually?

Thanks in advance

The quick way is to generate the create table statements of the tables and you will see the constraints and if you have constraints you may also check if you have DRI(declarative referential integrity). You can have constraints without DRI so check. Hope this helps.

Database Design Books

Hi folks,
Could some one suggest good Database Design books from
basic to InDepth . I have one from Wrox "Professional SQL
Server 2000 Database Design".
Thanks for the Help
ChipChip,
> Could some one suggest good Database Design books from
> basic to InDepth . I have one from Wrox "Professional SQL
> Server 2000 Database Design".
Database Design for Mere Mortals
Michael J. Hernandez
Addison Wesley, 1997
ISBN 0-201-69471-9
Data Modeling Essentials, 2nd Edition
Graeme C. Simsion
The Coriolis Group, 2001
ISBN 1-57610-872-4
Information Modeling and Relational Databases
Terry Halpin
Morgan Kaufmann, 2001
ISBN 1-55860-672-6
The Data Model Resource Book, Volume I
A Library of Universal Data Models for All Enterprises
Len Siverston
John Wiley & Sons, 2001
ISBN 0-471-38023-7
The Data Model Resource Book, Volume II
A Library of Universal Data Models by Industry Types
Len Siverston
John Wiley & Sons, 2001
ISBN 0-471-35348-5
Some online resources:
http://www.utexas.edu/its/windows/database/datamodeling/dm/design.html
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html
http://www.palslib.com/Fundamentals/Database_Design.html
http://www.martinfowler.com/articles/evodb.html
Linda|||Hi Linda,
Thank you very much for the books list and for pointing me
to some good resources.
Best Regards
Chip
>--Original Message--
>Chip,
>> Could some one suggest good Database Design books from
>> basic to InDepth . I have one from Wrox "Professional
SQL
>> Server 2000 Database Design".
>Database Design for Mere Mortals
>Michael J. Hernandez
>Addison Wesley, 1997
>ISBN 0-201-69471-9
>Data Modeling Essentials, 2nd Edition
>Graeme C. Simsion
>The Coriolis Group, 2001
>ISBN 1-57610-872-4
>Information Modeling and Relational Databases
>Terry Halpin
>Morgan Kaufmann, 2001
>ISBN 1-55860-672-6
>The Data Model Resource Book, Volume I
>A Library of Universal Data Models for All Enterprises
>Len Siverston
>John Wiley & Sons, 2001
>ISBN 0-471-38023-7
>The Data Model Resource Book, Volume II
>A Library of Universal Data Models by Industry Types
>Len Siverston
>John Wiley & Sons, 2001
>ISBN 0-471-35348-5
>
>Some online resources:
>http://www.utexas.edu/its/windows/database/datamodeling/dm
/design.html
>http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7
/node1.html
>http://www.palslib.com/Fundamentals/Database_Design.html
>http://www.martinfowler.com/articles/evodb.html
>
>Linda
>
>.
>

Database Design Books

Hi folks,
Could some one suggest good Database Design books from
basic to InDepth . I have one from Wrox "Professional SQL
Server 2000 Database Design".
Thanks for the Help
ChipChip,

> Could some one suggest good Database Design books from
> basic to InDepth . I have one from Wrox "Professional SQL
> Server 2000 Database Design".
Database Design for Mere Mortals
Michael J. Hernandez
Addison Wesley, 1997
ISBN 0-201-69471-9
Data Modeling Essentials, 2nd Edition
Graeme C. Simsion
The Coriolis Group, 2001
ISBN 1-57610-872-4
Information Modeling and Relational Databases
Terry Halpin
Morgan Kaufmann, 2001
ISBN 1-55860-672-6
The Data Model Resource Book, Volume I
A Library of Universal Data Models for All Enterprises
Len Siverston
John Wiley & Sons, 2001
ISBN 0-471-38023-7
The Data Model Resource Book, Volume II
A Library of Universal Data Models by Industry Types
Len Siverston
John Wiley & Sons, 2001
ISBN 0-471-35348-5
Some online resources:
http://www.utexas.edu/its/windows/d.../dm/design.html
http://www.cs.sfu.ca/CC/354/zaiane/...ter7/node1.html
http://www.palslib.com/Fundamentals...ase_Design.html
http://www.martinfowler.com/articles/evodb.html
Linda|||Hi Linda,
Thank you very much for the books list and for pointing me
to some good resources.
Best Regards
Chip
>--Original Message--
>Chip,
>
SQL
>Database Design for Mere Mortals
>Michael J. Hernandez
>Addison Wesley, 1997
>ISBN 0-201-69471-9
>Data Modeling Essentials, 2nd Edition
>Graeme C. Simsion
>The Coriolis Group, 2001
>ISBN 1-57610-872-4
>Information Modeling and Relational Databases
>Terry Halpin
>Morgan Kaufmann, 2001
>ISBN 1-55860-672-6
>The Data Model Resource Book, Volume I
>A Library of Universal Data Models for All Enterprises
>Len Siverston
>John Wiley & Sons, 2001
>ISBN 0-471-38023-7
>The Data Model Resource Book, Volume II
>A Library of Universal Data Models by Industry Types
>Len Siverston
>John Wiley & Sons, 2001
>ISBN 0-471-35348-5
>
>Some online resources:
>http://www.utexas.edu/its/windows/d...datamodeling/dm
/design.html
>http://www.cs.sfu.ca/CC/354/zaiane/.../notes/Chapter7
/node1.html
>http://www.palslib.com/Fundamentals...ase_Design.html
>http://www.martinfowler.com/articles/evodb.html
>
>Linda
>
>.
>