Entity-Relationship (ER) diagram for Lahman about lahman HOT 8 OPEN

I hope this tutorial will help: http://bergant.github.io/datamodelr/lahman.html

from lahman.

Perhaps we could use {dm} to both present the ER diagram and offer a data structure that has the keys integrated?

https://krlmlr.github.io/dm/

from lahman.

@bergant -- that's a great candidate for the vignette project! I had no idea that sort of functionality was available in R, but shouldn't have been surprised.

from lahman.

An example ER diagram or proof of concept would be welcomed

from lahman.

Looks interesting after a rather quick glance. I'd encourage anyone wanting to try this out in the short term to do so against the annual data update branch as there will be added data frames and potentially some (looking at you Master table..) removed.

I'm hoping to bring work on the annual data update to a close this weekend, and I'll update here as to where the best target branch is when it changes in a meaningful way.

from lahman.

I just added a graphic of the database schema I got from Sean Lahman to the README.md. Maybe this is sufficient

from lahman.

I think that the schema image addresses this issue nicely.

We don't want to lose the {datamodelr} example by @bergant, so I'll add it to the Vignette Introduction.

from lahman.

We don't want to lose the {datamodelr} example by @bergant, so I'll add it to the Vignette Introduction.

I just followed the {datamodelr} web connections, and see that the package has evolved/been incorporated into {dm}, which makes no mention of {Lahman}. I have a supplementary purpose for tackling this, so I'll put together a vignette demonstrating {dm} functions.

FYI: the {dm} page is here https://cynkra.github.io/dm/

from lahman.