Click here to Skip to main content
15,395,065 members
Home / Discussions / Database
   

Database

 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 4:34
mveRichard Deeming12-Feb-15 4:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:53
MemberKipkoechE12-Feb-15 4:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:03
MemberKipkoechE12-Feb-15 5:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:18
professionalGuyThiebaut12-Feb-15 5:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:23
MemberKipkoechE12-Feb-15 5:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:28
professionalGuyThiebaut12-Feb-15 5:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:05
MemberKipkoechE12-Feb-15 6:05 
QuestionAdd allowance to employee table is wrong or true according to my case Pin
ahmed_sa11-Feb-15 21:52
Memberahmed_sa11-Feb-15 21:52 
Hi guys I have problem i need to make ERD relation entity
between employee and allowance
Employee table
Name
address
Basic Salary
Bonus

Allowance table
House rent
Food Allowance
Moving Allowance

Basic Salary is monthly and fixed
Bonus is monthly and fixed
food allowance is monthly and fixed for married employee
House rent is monthly and fixed for some employee and some employee take house rent two time in year every 6 month
every employee married take 3 months salary from basic salary in year
suppose i m married and i take basic salary 5000
i will take rent 5000 x 3=15000/12=1250 monthly
some employee take rent every half year meaning every 6 month
meaning 15000/2=7500


My question according to my case above
Which is best put allowance in table allowance or put allowance(food,housing,moving)
in employee table and what relation between two tables
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 3:49
MemberDavid Mujica12-Feb-15 3:49 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 12:01
professionalMycroft Holmes12-Feb-15 12:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 19:19
MemberMember 1116162511-Feb-15 19:19 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 19:37
professionalKornfeld Eliyahu Peter11-Feb-15 19:37 
GeneralRe: Triggers Pin
John C Rayan12-Feb-15 3:32
professionalJohn C Rayan12-Feb-15 3:32 
QuestionRANKING IN VB.NET MYSQL Pin
KipkoechE10-Feb-15 22:27
MemberKipkoechE10-Feb-15 22:27 
SuggestionRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 0:06
mveRichard MacCutchan11-Feb-15 0:06 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 1:32
MemberKipkoechE11-Feb-15 1:32 
GeneralRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 1:36
mveRichard MacCutchan11-Feb-15 1:36 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 1:41
MemberKipkoechE11-Feb-15 1:41 
AnswerRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 2:11
professionalGuyThiebaut11-Feb-15 2:11 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:23
MemberKipkoechE11-Feb-15 2:23 
GeneralRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 2:28
professionalGuyThiebaut11-Feb-15 2:28 
QuestionVB.NET ITEXTSHARP PDF REPORTS Pin
KipkoechE10-Feb-15 6:38
MemberKipkoechE10-Feb-15 6:38 
QuestionMySQL for MFC application Pin
Anu_Bala10-Feb-15 0:14
MemberAnu_Bala10-Feb-15 0:14 
AnswerRe: MySQL for MFC application Pin
Kornfeld Eliyahu Peter10-Feb-15 2:37
professionalKornfeld Eliyahu Peter10-Feb-15 2:37 
Questionvb.net with mysql Pin
KipkoechE8-Feb-15 17:04
MemberKipkoechE8-Feb-15 17:04 

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.