I'm doing a project for learning programming in a python language with the django web framework. I don't know much about database and I don't really have to worry much because the django webframe handle almost everything. But, I do need to design the database and this is where I need help. I want a database for the baseball player bios like where they born, age, weight etc.. and for the stat, like how many hits, doubles, homer runs, etc... Base on my research I came with this design and I would like to know if it looks good, if not what should I change. This is what I came out :
Code:Table Player: player_id mlb_id name last middle jersey_number weight height birth_date birth_city = foreignkey (Cityborn) birth_country= foreignKey(Countryborn) pro_debut_date Primary_position = foreignkey(Position) team_name = foreignKey (team) throws_arm = foreignKey(Throws) bats_arm = Foreying Key(Bats) table Cityborn: name: Table Countryborn: name: table Position: name: table team: name: shortname: city: state: table Throws: arm: table Bats: arm: table seasonstat: player = foreignkey(player_id) year: hits: doubles: homeruns: rbi: average: table seasontotal: player = foreignkey(player_id) year: hits: doubles: homeruns: rbi: average:




Reply With Quote