Does this table need primarykey

Question

0.00/5 (No votes)

See more:

Emp_Code
OnDate
Attended
NotAttended
Total_Hours
Total_Minutes
Total_Seconds
Shift_Start_Time
Shift_End_Time

Emp_Code is the foreign key

Does this employee need foreign key??
the table would be updated daily.
If it needs primary key than what would be and if it doesnt need than why.

[Edit]: Shouting removed

Posted 20-Feb-14 21:05pm

Parth Dave

Updated 21-Feb-14 3:42am

Blutfaust

v2

Add a Solution

4 solutions

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)

Peter Leow · Answer 1 · 2014-02-20T21:16:00

Primary key are fields (single or multple) where their combination of values are unique in the table, i.e. no 2 records should have the same combination of values in these primary key fields.
Which fields where the combination of values in your table cannot be repeated, ask yourself this question, and you should be able to get the answer.
P.S. Do not use all-capital, it will draw flak instead of attention.

Raul Iloc · Answer 2 · 2014-02-20T21:17:00

Solution 2

1)You should add as primary key a new filed named "ID" for example, of type integer and with autoincrement.

2)foreign key should remain because is the link with data that come from other table (employee data);

Posted 20-Feb-14 21:17pm

Raul Iloc

RahulMGunjal · Answer 3 · 2014-02-20T21:44:00

Solution 3

For each employee if only one new record is added on each day in your table, then you can set Emp_Code & OnDate as Composite key to filter out duplicate records.

Emp_Code will act as Foreign Key as you said.

Posted 20-Feb-14 21:44pm

RahulMGunjal

Updated 20-Feb-14 21:48pm

v3

King Fisher · Answer 4 · 2014-02-20T22:04:00

Solution 4

Every table must have a Primary_key ,having a primary key (which by default also is the clustering key) can actually speed up many operations on SQL Server tables

Posted 20-Feb-14 22:04pm

King Fisher