How do I resolve having a M:N relationship in my Crow's Foot Model? Am I on the right track?
1
vote
2
answers
334
views
I am very much a beginner and taking a class on databases. My assignment involves using Crow's Foot notation to represent the following tables:
This is my design for it so far. I am nowhere near done but am I at least on the right track? I would have to use a composite entity to resolve the M:N relationships shown with these tables, right?
(Those M:N relationships being Employee to Plan and Benefit to Plan)
Please be forgiving of my work haha.
I really appreciate all of the help and insight!
Hope you all have a good one wherever you are!


Asked by RagingCalm
(11 rep)
Jun 19, 2021, 08:48 AM
Last activity: May 1, 2025, 10:02 PM
Last activity: May 1, 2025, 10:02 PM