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
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 the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal

Problem : (b) A deductive database system is essentially the outcome of applying mathematics logic to database management, where logic is used for both data representation and

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 w

What is the aim of logical schema ? The main motive of the logical schema is to ensure the portability of procedures and models on various physical schemas at runtime.

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo