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

Which model is used to store data in tree structures, 1. Which model is use... 1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures

#Advantages of dbms.., #explain five disadvantages of a dbms.. #explain five disadvantages of a dbms..

What are the categories of sql command, What are the categories of SQL comm... What are the categories of SQL command? SQL commands are separated in to the following categories: 1. Data - Definitition Language 2. Data Manipulation language 3. Dat

Case snerio, each publisher has uniqe name a mial addrs are also kept on ea... each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

Example for while until, Assume you are given a uniprocessor system with on... Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep

Data dictionary, how to prepare a data dictionary for online examination sy... how to prepare a data dictionary for online examination system for certified courses?

Functional dependency, Functional Dependency Consider a relation R that... Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

Define integrity, (a) Explain briefly the three parts of a relational Model... (a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

Update city of first bank corporation to new delhi, Change the city of Firs... Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

Describe all integrity constraints which are violated, Consider the two rel... Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all