ERD for Northwind db

[DickBaker]

suggestion to replace existing Figure 10.1 for more visual/logical learners

looking forward to the new .NET-9 release !

[markjprice]

I agree that it can be visually useful for the relationships lines to begin and end at the columns that are part of the foreign key relationship, although standard conceptual ER diagrams do not show this information. For the next editions of my books that use Northwind, I plan to use Mermaid for the ER diagram, as shown at the following link:
https://github.com/markjprice/cs13net9/blob/main/docs/ch10-er-diagram.md
As you can see, it cannot show which columns are defined in the relationship. I will consider manually using SQL Server database diagrams again to manually define the figure, and include a link to the online Mermaid diagram as an extra.

[DickBaker]

Mark, Hi Seen the Mermaid diagram and agree that it is secular-pink rich but information-poor - hope you err on the side of information rather than ideology :) Best Regards, Dick From: Mark J. Price ***@***.***> Sent: 09 October 2024 11:06 To: markjprice/cs12dotnet8 ***@***.***> Cc: Dick Baker ***@***.***>; Author ***@***.***> Subject: Re: [markjprice/cs12dotnet8] ERD for Northwind db (Issue #71) I agree that it can be visually useful for the relationships lines to begin and end at the columns that are part of the foreign key relationship, although standard conceptual ER diagrams do not show this information. For the next editions of my books that use Northwind, I plan to use Mermaid for the ER diagram, as shown at the following link: https://github.com/markjprice/cs13net9/blob/main/docs/ch10-er-diagram.md As you can see, it cannot show which columns are defined in the relationship. I will consider manually using SQL Server database diagrams again to manually define the figure, and include a link to the online Mermaid diagram as an extra. — Reply to this email directly, view it on GitHub <#71 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAVFJLFYIJBU6YJDLT7JN5TZ2T5X7AVCNFSM6AAAAABPT6LZYOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMBRHA4TAMRSHE> . You are receiving this because you authored the thread. <https://github.com/notifications/beacon/AAVFJLGQWDIOAF5KG2GVLQ3Z2T5X7A5CNFSM6AAAAABPT6LZYOWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTUPFHX3K.gif> Message ID: ***@***.*** ***@***.***> >