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
Outer Join: The use of Outer Join is that it still joins those tuples that do not have matching values in common columns are also contained in the result table. Outer join places

What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state

What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e


Question 1: (a) Planning and management of ICT projects have a very poor record in developing countries. Briefly explain five critical success factors for correct implementa

Use of partial data by applications : In common, applications work with views rather than whole relations. Thus, it may be more appropriate to work with subsets of relations rather

What is meant by heuristic optimisation?  Discuss the main heuristics that are applied during query optimisation.  Ans:  In heuristic optimization, heuristics are employed to r

What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto

Instructions: Follow the instructions below for completing this project: 1. Creating the Database: · Use the physical table descriptions given below to define and create each t