TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rajneesh Chaubey
NA
2.9k
234.9k
How to design database for sales tables in sql ??
Jan 21 2018 11:40 AM
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
Answers (
5
)
How to connect Xamarin.Android to SQL Server
SQL Server Loops