Entity Types PERSONNEL (personnel_id, fname, Iname, date_birth, place_birth) • PLAYER (batting_orientation, batting_average) o PITCHER(earn_run_average) • COACH • MANAGER • UMPIRE TEAM(Name, City, League, Division) GAME(Game_no, Date, Win_pitcher, Lose_pitcher, Save_pitcher) Relationships Relationship Type Participating Entities Manages Coaches Plays Cardinality Ratio (1:1, 1:N, M:N) From Entity 1 TO Entity 2 Entity 1 Entity 2 Manager Team Coach Team N:1 Player Team N:1 Participates Player Game M:N HOME_TEAM Team Game M:N AWAY TEAM Team Game M:N Participation constraint (total, partial) Entity 1 Entity 2 side side Total Total Total Total Total Total Partial Total Total Total Total Total Relationship Attribute Start_date Start_date Start_date hits(singles, doubles, triples, home_runs) Home_score(hits, runs, errors) Home_score(hits, runs, errors)