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
INTRODUCTION Databases and database systems have become an essential part of our daily life. We encounter many activities that involve some interaction with a database almost

E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database

Discuss how the one-to-one associations have to be implemented. Some of properties of associations can be implemented directly by providing suitable declarations of the data me

Submit the SQL Statements necessary to create your database according to the following guidelines: Your SQL statements should exactly mirror your ERD. All primary keys,


The First Normal Form (1NF) Let us first describe 1NF: Definition: A relation (table) is in 1NF if 1.      There are no duplicate tuples or rows in the relation. 2.

Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

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