I am writing a sports event result analyse of a database, there are few awards will be given
1. individual prize:
suppose getting champion get 5 marks , second runner up get 3 marks , etc
2. the most active athlete award
every student in a House participating every event gets 1 mark
3. the overall champion of a House in a school
what tables and schema do i need if i want to calculate marks from different event to present the awards...thank you