Define partial, alternate,artificial,compound &natural key, Database Management System

 

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







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
Related Questions
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


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

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 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. 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 : 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? Structured methodology treats data and their behaviours separately, and this makes it harder to isolate changes. If changes are re

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? Specifying alias: is used to rename column or attribute in a table.