InterviewUp – Job Interview Questions and Answers – What are partial, alternate,, artificial, compound...

December 01, 2008

Home

Sign-In

My Interview Questions

Question & Additional Information

UPs

What are partial, alternate,, artificial, compound and natural key?

Comments (0) |

Inappropriate

Asked By: mariann

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

Partial Key:

It is a set of attributes that can uniquely identify weak entities and that are related to same owner entity. It is sometime called as Discriminator.

Alternate Key:

All Candidate Keys excluding the Primary Key are known as Alternate Keys.

Artificial Key:

If no obvious key, either stand alone or compound is available, then the last resort is to simply create a key, by assigning a unique number to each record or occurrence. Then this is known as developing an artificial key.

Compound Key:

If no single data element uniquely identifies occurrences within a construct, then combining multiple elements to create a unique identifier for the construct is known as creating a compound key.

Natural Key:

When one of the data elements stored within a construct is utilized as the primary key, then it is called the natural key.

Tags

doctor, confident, inside, makes, me, what, is, it, in, that, to, be

Asked At

IMU (International Medical School) Malaysia

Job Positions

Medical school student

Click here to improve the Interview Question, Answer and other fields.

Comments (2) :

dk123

Wednesday, March 19, 2008 6:27 AM

nice comment

thingMaster

Tuesday, October 23, 2007 1:52 PM

you are overconfident. you will probably kill many patients, but drive a nice car.

See all 2 comments

UPs

How would you know whether a word takes a hyphen or not?

Add or view comments about this interview question

Comments (0) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Word combinations follow a natural progression over time. Whether nouns, verbs, or modifiers, or any mix of these elements, the combination typically goes from two terms (bed bug) to a hyphenated term (bed-bug) to one term (bedbug) as it becomes embedded in our language.

The easiest way to decide if a compound term takes a hyphen is to look it up in the latest edition of a good dictionary. Stick with that dictionary because dictionary spellings vary, and you want to be consistent.

A term that appears in your dictionary as one word (i.e., written solid) or as hyphenated has become a permanent compound. Remember that the dictionary spelling also depends on the property of the term: noun (workout) or verb (work out), adjective (call-in) or verb (call in), etcetera.

Create Date

Friday, October 19, 2007