Rajneesh Chaubey

Rajneesh Chaubey

  • NA
  • 2.9k
  • 233.7k

How to design database for sales tables in sql ??

Jan 21 2018 11:40 AM
Hi,I have a employee table having following data:-
  1. E_ID    E_Name  E_Zone  Username  Password
How do I design the tbltarget where I can keep track of targets for every employee on monthly basis. e.g. we can keep track of E_ID 501 has got how many target in sept month of 2017 and how many he achieved. I have designed the table like this way(below)
tbl_target :-
  1. TID EID Target  month   Achieved  
  2. 1   504 25     May        17  
  3. 2   501 28     Jan        15  
  4. 3   502 29     June       15  
  5. 4   503 30     April      16  
  6. 5   503 25     June       17  
  7. 6   501 29     April      22  
  8. 7   502 29     June       19  
  9. 8   504 30     March      20  
  10. 9   505 25     July       19  
  11. 10  501 29     May        24  
So, there is repetition of rows(E_ID).  Is there any effective method that you guys know that will work out here?? Pls let me know.

Answers (5)