Hall of Fame Nominated Team Member HallOfFame HallOfFame

7 Pages1207 Words492 Views

Added on 2020-04-01

About This Document

Each stadium has information about where it is located and contact number StadiumID PK StadiumName Name Name of the Stadium Address Stadium Address City Stadium City Name ContactNum Contact Number TeamID Which team are playing now FK Previous TeamStadium PK, FK TeamID Which TeamStadium It is a stadium. Each stadium has information about where it is located and contact number StadiumID PK StadiumName Name Name of the Stadium Address Stadium Address City Stadium City Name ContactNum Contact Number TeamID Which team are playing

Hall of Fame Nominated Team Member HallOfFame HallOfFame

Added on 2020-04-01

Related Documents

ERD

Hall of Fame Nominated Team Member HallOfFame HallOfFame_1

RelationshipsEach Person may have one or more play typesEach Hall of fame may nominate one or more team memberEach person may attend/join one or more collegesEach team member may get zero or more award in the year from the Professional Baseball Each team belong to a leagueEach union has one presidentPersonPlayerTypePlayTypeTeamMemberNominatedHallOfFamePersonCollegeAttendedCollegeTeamMemberMemberAwardBaseBallAwardTeamLeagueUnionPresidentUnion

Hall of Fame Nominated Team Member HallOfFame HallOfFame_2

Data DictionaryTable NameField NameDescriptionConstraintsPersonA person is a player or manager who plays base ballPersonID Person Identification NumberPKFirstNameFirst Name of the PersonLastNameLast Name of the PersonAddressPerson AddressCityPerson City NameStatePerson State NamePhonePerson Phone numberEmailPerson Email AddressPlayTypePlayType is a type which describes the player role of the baseball such as Pitcher,Fielder and ManagerPlayTypeIDPlay Type IDPKPlayTypeNamePlay Type Name Such as Pitcher, Fielder, ManagerPlayerTypeA person may have one or more play type. Each player may have different level of playing game such as Moderate, Good and excellentPersonIDPerson IDPK, FKPlayTypeIDPlay Type IDPK, FKSkillLevelSkill Level such as Moderate, Good, ExcellentCollegeA college is the educational institution. Person may join and study the course.CollegeIDCollege IDPKCollegeNameName of the CollegeAddressCollege AddressContactNumberContact NumberCollegeAttendedA person may join zero or more colleges in the academic year and attend the course and will get the degree from the collegeCollegeIDCollege IDPK, FKPersonIDPerson IDPK, FKAcademicYearAcademic Year JoinedPKReportCollege Record such as Grade, Course details and etcLeagueIt is a group of baseball clubs which play with each other. Each league has a period (start and end date)LeagueIDLeague ID PKLeagueTitleTitle of the LeagueLeagueStartStarting Date of LeagueLeagueEndEnding Date of LeagueTeamIt is a baseball team which is formed by leagueTeamIDTeam IDPKTeamNameTeam NameLeagueIDLeague IDFK

Hall of Fame Nominated Team Member HallOfFame HallOfFame_3

End of preview

Want to access all the pages? Upload your documents or become a member.