Click here to Skip to main content
15,508,758 members
Home / Discussions / Database
   

Database

 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:53
KipkoechE12-Feb-15 5:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:03
KipkoechE12-Feb-15 6:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:18
professionalGuyThiebaut12-Feb-15 6:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:23
KipkoechE12-Feb-15 6:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:28
professionalGuyThiebaut12-Feb-15 6:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 7:05
KipkoechE12-Feb-15 7:05 
QuestionAdd allowance to employee table is wrong or true according to my case Pin
ahmed_sa11-Feb-15 22:52
ahmed_sa11-Feb-15 22:52 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 4:49
David Mujica12-Feb-15 4:49 
Some things to consider in your design ...

How about a design like this:

employee Key
Allowance Code
Effective_Start_Date
Effective_End_Date
Allowance Rate

This may not be complete, but what it does for you is that it allows for many types of allowance codes to be associated with an employee, each allowance code has an effective date range with an associated rate. This also allows for 2 employee who have the same allowance code to be compensated differently.

You would then need another table which translates the Allowance Code to a description.

I use a similar approach when dealing with prices, you have the history of the prices over time ...

Just a thought.
Good luck. Thumbs Up | :thumbsup:
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 13:01
professionalMycroft Holmes12-Feb-15 13:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 20:19
Member 1116162511-Feb-15 20:19 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 20:37
professionalKornfeld Eliyahu Peter11-Feb-15 20:37 
GeneralRe: Triggers Pin
John C Rayan12-Feb-15 4:32
professionalJohn C Rayan12-Feb-15 4:32 
QuestionRANKING IN VB.NET MYSQL Pin
KipkoechE10-Feb-15 23:27
KipkoechE10-Feb-15 23:27 
SuggestionRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 1:06
mveRichard MacCutchan11-Feb-15 1:06 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:32
KipkoechE11-Feb-15 2:32 
GeneralRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 2:36
mveRichard MacCutchan11-Feb-15 2:36 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:41
KipkoechE11-Feb-15 2:41 
AnswerRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 3:11
professionalGuyThiebaut11-Feb-15 3:11 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 3:23
KipkoechE11-Feb-15 3:23 
GeneralRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 3:28
professionalGuyThiebaut11-Feb-15 3:28 
QuestionVB.NET ITEXTSHARP PDF REPORTS Pin
KipkoechE10-Feb-15 7:38
KipkoechE10-Feb-15 7:38 
QuestionMySQL for MFC application Pin
Anu_Bala10-Feb-15 1:14
Anu_Bala10-Feb-15 1:14 
AnswerRe: MySQL for MFC application Pin
Kornfeld Eliyahu Peter10-Feb-15 3:37
professionalKornfeld Eliyahu Peter10-Feb-15 3:37 
Questionvb.net with mysql Pin
KipkoechE8-Feb-15 18:04
KipkoechE8-Feb-15 18:04 
AnswerRe: vb.net with mysql Pin
PIEBALDconsult8-Feb-15 18:33
professionalPIEBALDconsult8-Feb-15 18:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.