title: How to create database table insert data in monthly including calculation
body: <p>I'm creating a system which is staff can submit their evaluate marks of the maintenance work of golf course in monthly. The evaluation in each hole.Marks will insert in 1 to 5 marks in each hole.</p>
  
  <p>The column are the category of job, job of work, frequency,hole1,hole2, hole3, hole4.</p>
  
  <p>Moreover, the category of job, job of work, frequency can insert new and can be updated by user if needed.</p>
  
  <p>After evaluating marks need to calculate each hole job have been done in percentage. I decide total all the marks in divide how many jobs have.</p>
  
  <p>However, my issue is with the DB Design, I don't know how to design it to make it work.</p>
  
  <p>So far my Idea is:</p>
  
  <p>(No. varchar(5), JobCategory varchar(15), JobLocation Varchar(15), Hole1 int, Hole2 int, Hole3 int, Hole4 int, Hole5 int, Marks int)</p>
  
  <p>but how do I record in monthly? <strong>because i have already key in all the category, job, frequency left hole(marks) only enter by user</strong>
  <a href="https://i.stack.imgur.com/4kyuT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4kyuT.png" alt="enter image description here"></a></p>
  
  <p>I need enter my marks something like this
  <a href="https://i.stack.imgur.com/Ye2WL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ye2WL.png" alt="enter image description here"></a></p>
  
  <p>Could anyone help please?</p>
  
  <p>Thanks</p>