explaining a random ERD
Hi, Emmanuel here. So first off, I know nothing about fantasy football, or much about football for that matter, so I'm going to write my honest take on this model. This will also be me writing in my own style, so I'll exercise some of the writing skills I have been practicing since the start of this year. So brace yourself, and I apologize in advance for the fact that you have to sit there and take valuable time off your day to read my wannabe New York Times bestseller jabbering and ramblings. Let's begin. In general, we have what's called an ERD, an entity-relationship diagram, if I picked up anything from undergrad times. The model consists of 10 entities: League, Owner, Fantasy Team, Player, Position, NFL Team, Fantasy Game, NFL Game, Relevant Play, and Play Type. They are all connected to each other one way or another; we shall try to get into those connections as we go along. Let's start with the Player, who plays a position captured in the Position table. Fo