title: mysql database logic
body: <p>My question is more of trying to understand what and how I can get something done. Here's the thing:</p>
  
  <p>I got a job to build this application for a school to manage student bio data, work-out and handle student information and basic finance management. </p>
  
  <p>Based on requirements I got from meets with my client, I have an ERD of a proposed MySQL Database with 23 different tables. The one part I would like to understand quickly is displaying data based on school terms. There are 3 terms in a year, each with its own summaries at the end of each term. At the end of 3 terms, a year has gone by and a student is promoted or demoted. </p>
  
  <p>So my question is, how can I render my data to show 3 different terms and also to create a new year working out how to either promote a student or make the student repeat the class its in?</p>