search

markjprice / cs12dotnet8

Repository for the Packt Publishing book titled "C# 12 and .NET 8 - Modern Cross-Platform Development Fundamentals" by Mark J. Price
594 stars 176 forks source link

ERD for Northwind db #71

Open DickBaker opened 2 days ago

DickBaker commented 2 days ago

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

looking forward to the new .NET-9 release !

markjprice commented 2 days ago

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 commented 1 day ago

Mark, Hi

Seen the Mermaid diagram and agree that it is secular-pink rich but information-poor

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 https://github.com/markjprice/cs12dotnet8/issues/71#issuecomment-2401890229 , 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: @. @.> >