Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to design database for sales tables in sql ??
Rajneesh Chaubey
Jan 21 2018 11:40 AM
218
Hi,I have a employee table having following data:-
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 :-
TID EID Target
month
Achieved
1 504 25 May 17
2 501 28 Jan 15
3 502 29 June 15
4 503 30 April 16
5 503 25 June 17
6 501 29 April 22
7 502 29 June 19
8 504 30 March 20
9 505 25 July 19
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.
Reply
Upload Source Code
Select only zip and rar file.
Post
Reset
Answers (
2
)
How to connect Xamarin.Android to SQL Server
SQL Server Loops