Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ER diagram without cardinality (just crowsfeet) #4777

Open
jameshowison opened this issue Aug 27, 2023 · 2 comments
Open

ER diagram without cardinality (just crowsfeet) #4777

jameshowison opened this issue Aug 27, 2023 · 2 comments
Labels
Status: Triage Needs to be verified, categorized, etc Type: Enhancement New feature or request

Comments

@jameshowison
Copy link

jameshowison commented Aug 27, 2023

Proposal

The ER diagram is great. For teaching, I like to use ER diagrams with just straight lines and the crows foot, avoiding the minimum cardinality and optionality.

(why? I find these add complexity for students who are learning where foreign keys go, and these elements of modeling don't impact relational table/column layout).

I know this is also not available in PlantUML notation, so it might be tricky. But perhaps just dropping the 0 and | parts or the relationships? Or adding a - to indicate not including either the one or the 0

Equally one could argue for just adding to the aliases one and many (where one is rendered as a | through one end of the line, I could definitely work with that rather than the empty line ending).

I guess I'd like to have the full set of options depicted in the lower half of https://www.vivekmchawla.com/erd-crows-foot-relationship-symbols-cheat-sheet/

Example

Here I'm using the > or < symbol to represent a crowsfoot.

Team ---{ Player  (one to many)

Team -----------< Player
Book }--{ Genre  (many to many)

Book >----< Genre

or

Team |--{ Player  (one to many)

Team -|----------< Player

Screenshots

No response

@jameshowison jameshowison added Status: Triage Needs to be verified, categorized, etc Type: Enhancement New feature or request labels Aug 27, 2023
@jameshowison
Copy link
Author

I'd take a shot at implementing this, any guidance?

@Palkers76
Copy link

It would be nice to have a relationship line starting from attribute/column to referenced PK & Entity
Also arranging Entities and relationship lines can became messy, would be good to allow different options to arrange it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Status: Triage Needs to be verified, categorized, etc Type: Enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants