surrogate key in database world
Hi,
when we use surrogate key in database world. what is its importance of it. please advise
when we use surrogate key in database world. what is its importance of it. please advise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dale Fye
sounds like a homework question. If it is, be advised that experts are prohibited from answering homework questions.
LOL, gudii9 is 8 years here and he is solving his homeworks all the time.
pcelba,
I don't generally hang out in some of the topic areas the OP posted in, but it sounds like a homework question, doesn't it? If you didn't know this OP from previous interaction, wouldn't that cross your mind?
Dale
I don't generally hang out in some of the topic areas the OP posted in, but it sounds like a homework question, doesn't it? If you didn't know this OP from previous interaction, wouldn't that cross your mind?
Dale
@Dale Fye:
Not at all. Gudii9 is answering questions here and if he asks in the area which is not his/her domain then I help even when the answer is on the net already.
Of course, if you rather start looking for reasons why to ban the author or mark the question as possibly rule violation candidate then it is your way of thinking. Nothing against you but if you want to post something against gudii9 then look at his profile first.
@gudii9:
To read more about Surrogate keys you may start here: https://en.wikipedia.org/wiki/Surrogate_key
The visible key mentioned in my answer is rather called Business key or Natural key: https://en.wikipedia.org/wiki/Natural_key
Not at all. Gudii9 is answering questions here and if he asks in the area which is not his/her domain then I help even when the answer is on the net already.
Of course, if you rather start looking for reasons why to ban the author or mark the question as possibly rule violation candidate then it is your way of thinking. Nothing against you but if you want to post something against gudii9 then look at his profile first.
@gudii9:
To read more about Surrogate keys you may start here: https://en.wikipedia.org/wiki/Surrogate_key
The visible key mentioned in my answer is rather called Business key or Natural key: https://en.wikipedia.org/wiki/Natural_key
@pcelba,
I didn't post anything against gudii9, if you read my original post I asked a question and stated the position of EE regarding homework. I was viewing the question from my iPhone and didn't think about looking at the poster profile on that device, although I generally do when answering questions from my phone.
Even if I had looked at the OPs profile, there is nothing there to suggest that he/she is not a student and that this is not a homework question. As you can see by my profile and history, I've been here a while and answer most any question that is posted, but some questions just smell like homework questions, and I generally post a similar response when it smells that way to me. Usually, I get a response from the OP and provide the requested assistance. Occasionally, the OP doesn't respond, or indicates that it is in fact homework, in which case I attempt to assist within the bounds of EE guidelines.
I didn't post anything against gudii9, if you read my original post I asked a question and stated the position of EE regarding homework. I was viewing the question from my iPhone and didn't think about looking at the poster profile on that device, although I generally do when answering questions from my phone.
Even if I had looked at the OPs profile, there is nothing there to suggest that he/she is not a student and that this is not a homework question. As you can see by my profile and history, I've been here a while and answer most any question that is posted, but some questions just smell like homework questions, and I generally post a similar response when it smells that way to me. Usually, I get a response from the OP and provide the requested assistance. Occasionally, the OP doesn't respond, or indicates that it is in fact homework, in which case I attempt to assist within the bounds of EE guidelines.