Describe the Composite Key

Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the whole school, merely searching by the Roll is not enough, because there could be 10 classes in the school and every one of them may have a certain roll no 5. To uniquely recognize the student we have to say something like "class VII, roll no 5". So, a combination of two or more attributes is combined to make a unique combination of values, such as Class + Roll.

 

Posted Date: 7/26/2013 6:12:39 AM | Location : United States

Ask an Expert

Related Discussions:- Describe the composite key, Assignment Help, Ask Question on Describe the composite key, Get Answer, Expert's Help, Describe the composite key Discussions

Write discussion on Describe the composite key
Your posts are moderated

Write your message here..

Related Questions

Develop a database design , A practice called Perfect Pets provides private... A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

What is hash file organization, What is hash file organization? What are t... What is hash file organization? What are the causes of bucket overflow within a hash file organization? What can be completed to decrease the occurrence of bucket overflow?

The proliferation of object-oriented methods, The Proliferation of Object-O... The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g

Express the ways provided by mysql for pattern matching, Express the ways p... Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

Describe parameteric end users, Describe Parameteric end users? Paramet... Describe Parameteric end users? Parametric end users might be given update access, but are commonly not permitted to change the structure of data.

Developer competent in data cleansing-data scrubbing, Data Scrubbing 70,000... Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

Timestamp type, Do NOT use the timestamp type.  Use separate date and time ... Do NOT use the timestamp type.  Use separate date and time data types only.  Figure out how to define an SQL insert statement that uses built-in SQL (or MySQL) functions to define

Er diagram of textile industry, complete er diagram of textile industry man... complete er diagram of textile industry management

Database system, how the string works as keyword? how the string works as keyword?

What is cardinality ratio, What is Cardinality Ratio? Cardinality Rati... What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa