Hi All

-
Hi All
I need Advice i am doing School Software, i need to feed data for Students Exam Result Term wise ( 3 Terms) please advice it is better to keep 3 Table for Each Term or 1 Table for 3 Terms ?

Comments

  1. Kevin PowickJuly 4, 2016 at 12:57 PM

    One table, with a field to indicate the term.

    ReplyDelete
  2. Dany MarmurJuly 4, 2016 at 2:19 PM

    No, normalise, IMO. One table for Students, one table for Terms (3 records or 3 x each year). Exams is a table of it's own with one relation to student and one to Terms plus a unique constraint on the two relations concatenated. For reports, edits et. al. denormalise using joins. You may now retrieve statistics any way you like. Avg grades for male student in the last term each year compared to the first term and so on.

    ReplyDelete

Post a Comment