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

Data, Explain three main attributes of data. Explain three main attributes of data.

Abap/4 program, It is not possible to make an ABAP/4 program, which having ... It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

Concurrency control, discuss the purpose of the concurrency control? discuss the purpose of the concurrency control?

Operator precedence-data manipulation language, Operator Precedence The... Operator Precedence The basic operators used in SQL are * /   - + Operators of the similar priority are evaluated From Left to right Parentheses are used to force priorit

Components of a typical database environment, Question: (a) List four d... Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

A database administrator'', A database administrator''s responsibilities an... A database administrator''s responsibilities and data contents

Express types of information available in mysql, Express types of informati... Express types of information available in MySQL? Information as regards the result of queries:  This includes number of records affected by any SELECT or UPDATE or DELETE st

State the data flow diagram of functional model, State the data flow diagra... State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

Hashed file organisation, Hashed File Organisation Hashing is the most ... Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

Define deadlock term, a. Define the term "deadlock". There are four conditi... a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.