(Solved): crows foot model 2. Create an E/R diagram for a database recording information about teams, playe ...

crows foot model

2. Create an $\mathrm{E}/\mathrm{R}$ diagram for a database recording information about teams, players, and their fans. Each team has a team name with players, a team captain (one of its players), and the colors of its uniform (don't make this multi-valued -[assume every team has two colors). Each player has his/her name (remember - atomic attributes) and a position (just one position). 3. Each fan has his/her name (again - make atomic), favorite teams (notice this is plura!!), and favorite players (again plural!). For data integrity reason, include a lookup table for a list of positions. Note: a lot of beginners will start adding attributes like pitcher, catcher, quarterback, guard, ... These are not the attributes. These are data. When you design, you don't concern yourself with the specific data. The lookup table should not have specific positions. Here is an example, if I need a STATE lookup table, I don't have Alabama, Alaska, Arizona, ... as attributes. That is the data. I have STATE_NAME or STATE_ABBR as the attribute names.