Database diagram

Hi all,
is it possible (with SS2005) to create a database diagram with the
arrows near the tables' fields that have a relation?
With my SQL Server 2005 database diagram, the arrows are placed
casually, not near the fields that are related with other tables.
Thanks in advance.
LuigiUnfortunately you have to jigger the arrows around by hand--drag the
ends to the fields where they belong. It takes a little time (and can
be exasperating when you end up with little loops) but it can be done.
--Mary
On 22 Feb 2007 06:34:25 -0800, "ciupaz" <luigi.zambetti@.gmail.com>
wrote:
>Hi all,
>is it possible (with SS2005) to create a database diagram with the
>arrows near the tables' fields that have a relation?
>With my SQL Server 2005 database diagram, the arrows are placed
>casually, not near the fields that are related with other tables.
>Thanks in advance.
>Luigi

Database Design

Can anyone tell me how can i design database architecture for the Table Category & Product...so that i can make N-level entity relation...

I have database in SQL SERVER 2000.

CategoryId
CategoryName
ParentId

Here ParentId is CategoryId. for root category it is null

productId
ProductName
CategoryId

|||

Visit below thread.

http://forums.asp.net/t/1162732.aspx