Member Avatar for iamy1204

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

  • 2 Contributors
  • 3 Replies
  • 74 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by SKANK!!!!!
Member Avatar for SKANK!!!!!

a table for events and a table for users

Member Avatar for iamy1204

i know i have to set the above two tables....but how to calculate marks...or what sql i need to use?

Member Avatar for SKANK!!!!!

have a column in users for marks. and when someone gets a mark update it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.