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
Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?

File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is

I need web security expert , website management Project Description: i want professional for the below . website management server management database management

Which is the properties of entities? Attributes is the properties of entities.

Explain the challenges before an E-business management.

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

Describe the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.

explain various steps uses in evaluation and maintenance of MIS.

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio