in database

Question

0.00/5 (No votes)

See more:

in database
I have 4 table4

Table 1: worker (name , id , sex , salary , specialty )
Table 2: customer (name , id , bill , date of visit)
Table 3: service (servise id , type)
Table 4: order (orderNo , worker id , worker name , serviceID , date , custemorID)

in table 4 i have PK "orderNo" , FK "workerID" , and FK "workerNAME"

are (workerId and workerName) Composite PK ??

or composite FK??

and how can create it in oracle?

if the PK is "orderOn"

Posted 2-Jan-11 21:44pm

malemar

Add a Solution

Comments

Sandeep Mewara 3-Jan-11 3:57am

Your question is not quite clear. What are you asking? Are you looking for table design? scripts? suggesting soemthing? Asking?

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)

Hiren solanki · Answer 1 · 2011-01-02T22:07:00

I know you've asked this question again by providing some little clarity with your question. That isn't a good practice, Either update previous one we will then also get notification that you've asked question here.

I think you have some misunderstanding about PK,FC,CK and probably in Database design too, for that refer database normalization[^] for getting better understanding for yourself for some of your question. Like,

if you're including workerid in Order table then there's no need to include worker name there as you can get it easily by Join in query.

second, you've asked are (workerId and workerName) Composite PK ??, If worker id is a different for every worker then workerid can itself identify record uniquely then why are you adding another one column to make it CK ?

I've told you in previous question also that CK is needed when one key is not enough to identify record uniquely.