solving a problem query related

Question

1.00/5 (1 vote)

See more:

let us have two tables such as employee table and salary table in which employee id is a primary key

as we know primary key eradicates duplicate values

first we insert the salary of particular employee in first month

but during insertion of second month salary of that employee we will get primary key error

but we need to solve this problem

how can we solve it

waiting for ur responses ?

Posted 5-Mar-12 19:32pm

gowthammanju

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

psgviscom · Accepted Answer · 2012-03-05T19:38:00

Solution 1

Hi,
In employee table keep employee id as primary key. In salary table keep employee id as foreign key with reference as employee table. Then you can add first month salary as well as second month for particular id in your salary table. This solves your problem.

Posted 5-Mar-12 19:38pm

psgviscom

Updated 5-Mar-12 19:42pm

v3

Comments

gowthammanju 6-Mar-12 1:56am

ya ur solution is k for me if we have combined both the table in single table den how is it possible

gowthammanju 6-Mar-12 1:58am

if we have fields such as empid,emname,salary,date in a table let us assume primary key is empid we need to insert the salary month by month how it will be possible

psgviscom 6-Mar-12 4:40am

There is no possibility in creating duplicates to primary key field. Better create two tables. Otherwise don't use primary key.