Jan 05, 2021 10:00 PM|wavemaster|LINK
bId, gId, sId are the names of the primary keys in 3 lookup tables, specifying a type characteristic of Client.
In the diagram in SSMS there is a many symbol on the Client side and a key symbol on the Type side
In words, this is a one to many relationship::
There are many Clients who have one Breed Type
One Client has one Breed Type
After reviewing the link provided by mgebhard, and watching some more youtube videos I thin what I have should work, but I am still no further than I was before Christmas.
Gut feeling says it has something to do with the addition of "Navigation" to the name of the primary key
Where do I go from here? Stack Overflow is a non-starter.