Super keys, Database Management System

A super key is an attribute or set of attributes used to recognize the records uniquely in a relation.

For instance, in the Relation PERSON defines earlier PERSON_ID is a super key since PERSON_ID is unique for every person. Likewise (PERSON_ID, AGE) and (PERSON_ID, NAME) are also super keys of the relation PERSON as their combination is also unique for each record.

Posted Date: 3/6/2013 5:23:51 AM | Location : United States

Related Discussions:- Super keys, Assignment Help, Ask Question on Super keys, Get Answer, Expert's Help, Super keys Discussions

Write discussion on Super keys
Your posts are moderated
Related Questions
Which data type can store unstructured data? Raw data type can store unstructured data.

What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a

create an er diagram for production management in film industry

Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) we

Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Rules Of Data Normalisation  Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process: 1.