Skip to content
This repository has been archived by the owner on Sep 25, 2021. It is now read-only.

Crow's foot notation: Zero or One #8

Closed
simeonlin opened this issue Apr 22, 2020 · 3 comments
Closed

Crow's foot notation: Zero or One #8

simeonlin opened this issue Apr 22, 2020 · 3 comments
Labels
enhancement New feature or request

Comments

@simeonlin
Copy link

I think there should be an improvement on the crow foot notation on the relationships.
From Wikipedia: (https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model#Crow's_foot_notation)

Three symbols are used to represent cardinality:
-the ring represents "zero"
-the dash represents "one"
-the crow's foot represents "many" or "infinite"
These symbols are used in pairs to represent the four types of cardinality that an entity may have in a relationship. The inner component of the notation represents the minimum, and the outer component represents the maximum.

ring and dash → minimum zero, maximum one (optional)
dash and dash → minimum one, maximum one (mandatory)
ring and crow's foot → minimum zero, maximum many (optional)
dash and crow's foot → minimum one, maximum many (mandatory)

Issues:

  • At the moment to-many-relationships are marked with three symbols ring, dash and crow's foot instead of only ring and crow's foot.

  • And if I mark a foreign-key-column in the List-view as mandatory the symbol stays at 'ring and dash' instead of 'dash' or 'dash and dash'.

(Just found this VS Code-Extension and I'm amazed!) 🥇

@dineug
Copy link
Owner

dineug commented Apr 22, 2020

(ZeroOne, ZeroN, OneN, OneOnly, N)
Now I know!

But I don't think it's going to be possible for me to revise it now.

I'm preparing for major version 1.0.
The current version only planned to fix important bugs.

Instead, I will reflect the notation you told me in 1.0!

Thanks for letting me know!

@simeonlin
Copy link
Author

Ok, thank you that's fine! 👍

Do you already have a time horizon for 1.0?
Just: Is it about weeks or months? :)
I'm considering using your great tool in my database-courses I'm teaching.

@dineug
Copy link
Owner

dineug commented Apr 22, 2020

I'm thinking maybe it'll be completed between June and July.

@dineug dineug closed this as completed in c5054e1 Apr 30, 2020
@dineug dineug added the enhancement New feature or request label Sep 5, 2020
dineug added a commit that referenced this issue Apr 11, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants