Partial Key: It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.

 Alternate Key: All Candidate Keys remaining the Primary Key are called as Alternate Keys.

 Artificial Key: If no obvious key either compound or stands alone is available, then the last resort is to simply give a key, by assigning a distinct number to every occurrence or record. Then this is called as developing an artificial key.

 Compound Key: If no single data component uniquely identifies occurrences within a developed, then combining multiple components to make a distinct identifier for the construct is called as creating a compound key.

 Natural Key: When one of the data components stored within a construct is used as the primary key, and then it is known the natural key.

 

Posted Date: 7/30/2012 2:28:40 AM | Location : United States

Ask an Expert

Related Discussions:- Define partial, alternate,artificial,compound &natural key, Assignment Help, Ask Question on Define partial, alternate,artificial,compound &natural key, Get Answer, Expert's Help, Define partial, alternate,artificial,compound &natural key Discussions

Write discussion on Define partial, alternate,artificial,compound &natural key
Your posts are moderated

Write your message here..

Related Questions

Explain the cascadeless schedule, Explain the Cascadeless Schedule A ca... Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit

Primary key, what is primary key what is primary key

Which component is not included in database environment, Which component is... Which component is not included in database environment ? A users component is not included in database environment.

Differentiate between pl/sql functions and procedures, Oracle & Distributed... Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

What is candidate key, What is Candidate Key Super Key or Candidate Ke... What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Define physical and logical data independence, Define physical and logical ... Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

Update anomaly-data redundancy, Update Anomaly : This anomaly is occurred d... Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

What are shortcomings in structured approach, What are shortcomings in stru... What are shortcomings in structured approach? Structured methodology treats data and their behaviours separately, and this makes it harder to isolate changes. If changes are re

Difference between functions along with or without grouping, Explain the di... Explain the difference between using functions along with and without grouping attributes in relational algebra. Give examples. Ans: Group functions are used to group data of

What is the used of specifying alias, What is the used of specifying alias?... What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.