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

DBMS, WHAT IS DBMS WHAT IS DBMS

I want to get database of a website, Project Description: I would like t... Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

Normalization assigment, what would go in order patient#, patient name, pat... what would go in order patient#, patient name, patien address, surgeon#, surgeon name, surgery date, surgery type, drug admin

Explain what is ddl, Explain what is DDL? DDL - Data Definition Languag... Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT

Database Management System, Assume that you are responsible for selecting a... Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Recovery concepts, recovey techniques based on deferred update and immediat... recovey techniques based on deferred update and immediate update

Sources of utilities for a dbms, There are three main sources of utilities ... There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally

Define the concept of design documentation, Design Documentation  The ... Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Database system design and Implementation, Consider a typical sales invoice... Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info

Define lock, Define lock? Lock is the most common used to execute the r... Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.