Relationship error in table design

Can someone explan the following error message:

RMDB_TABLE DESIGN_V2.VSD : warning L3017: 'tblCityStateCountryAssgn_tblCityDetail_FK1' : Relationship has cardinality other than either zero-or-one or exactly-one, yet the child columns form a key.

I am testing my table design in Visio 2010 - Not sure what this means.
Karen SchaeferBI ANALYSTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
Seems like an issue when assigning PKs and FKs:

Database Schema Design (Visio Forward engineering error)

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Arthur_WoodCommented:
Please show the schemas (layouts) of both tables.
0
Karen SchaeferBI ANALYSTAuthor Commented:
Gustav, I already read the article, unfortunately, I do not have multiple pk in tables, I may have duplicate FK for my M-M Tables, with the fields renamed.

I have attached my schema and yes I am using the forward engineeing addin.  I have been able to narrow down the number of issues However, I am unsure how to handle the remaining issues.  any insight would be greatly appreciated.

RMDB-Table-Design-3.vsd
Starting Logical Validation...
RMDB_TABLE DESIGN_3.VSD : error L3020: 'tblBaseLevelTC_Detail_tblTC_CascadingAssignments_FK1' : Foreign key relationship has same parent and child tables as tblBaseLevelTC_Detail_tblTC_CascadingAssignments_FK2, but does not have different forward and inverse verb phrases.
RMDB_TABLE DESIGN_3.VSD : warning L3017: 'tblTC_Exemptions_Detail_tblRDExemptionAssignment_FK1' : Relationship has cardinality other than either zero-or-one or exactly-one, yet the child columns form a key.
RMDB_TABLE DESIGN_3.VSD : warning L3013: 'tblCountry_tblCityStateCountryAssgn_FK1' : Relationship has a cardinality of either zero-or-one or exactly-one, yet the child columns do not form a key.
RMDB_TABLE DESIGN_3.VSD : error L3014: 'tblBaseLevelTC_Detail_tblTC_Calc_CascadingTemp_FK1' : Foreign key relationship is identical to tblBaseLevelTC_Detail_tblTC_Calc_CascadingTemp_FK2.
RMDB_TABLE DESIGN_3.VSD : error L3020: 'tblBaseLevelTC_Detail_tblTC_Calc_CascadingTemp_FK1' : Foreign key relationship has same parent and child tables as tblBaseLevelTC_Detail_tblTC_Calc_CascadingTemp_FK2, but does not have different forward and inverse verb phrases.
RMDB_TABLE DESIGN_3.VSD : warning L3011: 'tblBaseLevelTC_Detail_tblTC_Calc_CascadingTemp_FK1' : Child columns overlap with child columns of tblBaseLevelTC_Detail_tblTC_Calc_CascadingTemp_FK2.
RMDB_TABLE DESIGN_3.VSD : warning L3012: 'tblTC_RD_Detail_tblRDExemptionAssignment_FK1' : Cardinality 'Zero-or-One-to-One-or-More' or 'Zero-or-One-to-Exactly-N' is highly unusual.
Logical Validation complete - 3 error(s) 4 warning(s)

Open in new window

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Visio

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.