'Confused on the difference between One, and One and Only One in ERDs
Sorry for the links I'm new! I'm confused on the difference between one and one and only one and where they would be used. I just started the class so I apologize if my diagram is wrong as well.
Solution 1:[1]
Maybe too late, but I think this is good answer for you from Wiki: "The inner component of the notation represents the minimum, and the outer component represents the maximum"
And more visualize: https://www.vertabelo.com/blog/crow-s-foot-notation/
So in your case: "Any patient who is admitted must have exactly one admitting physician" need an One and only one relationship. I think your diagram is alright. Keep going on
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | nobody |