What is the difference between a key and a superkey, Database Management System

What is the difference between a key and a superkey?

Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one or more examples (rows) of the set (table). It is a minimal combination of attributes.

Super Key - A super key is a set of one or more attributes in which, taken collectively, permits us to identify uniquely a tuple within the relation.

Posted Date: 5/10/2013 4:04:07 AM | Location : United States







Related Discussions:- What is the difference between a key and a superkey, Assignment Help, Ask Question on What is the difference between a key and a superkey, Get Answer, Expert's Help, What is the difference between a key and a superkey Discussions

Write discussion on What is the difference between a key and a superkey
Your posts are moderated
Related Questions
what is Mapping Constraints? with examples

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Determine the advantage of object-orientation Finally, object-orientation has advantage of continuity throughout analysis, persistent representation and design implementation.

This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru.

How to create a table from existing table? Create table as e.g, To create a new table ‘N_emp' with employee names and their identification numbers only from employee ta

triggering

What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri

Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

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