| jimmy |
Posted: Mar 18, 2007 05:49:15 AM |
Total Post: 9
Joined: Feb, 2007
|
| plz tell me the diff between tuple and attribute and also about composite key and super key |
|
|
deal |
| Posted: Mar 18, 2007 10:43:50 AM | |
|
Total Post: 21
Joined: Nov, 2006
|
Attributes are represented as columns in a table and
each attribute in a relation is unique and contains some value.
The no, of attributes in a relation is called degree of relation
Tuple is a row in a table.The number of tuples in a relation
is called cardinality of relation.
|
|
|
|
|
deal |
| Posted: Mar 18, 2007 10:48:59 AM | |
|
Total Post: 21
Joined: Nov, 2006
|
As far as I know a
composite key is a primary key that consists of more than
one column whereas as super key can consist of
a single or more than one column which idetifies a row uniquely.
|
|
|
|
|
Rush |
| Posted: Mar 19, 2007 12:16:44 AM | |
|
Total Post: 127
Joined: Jan, 2007
|
hi,
composit key may or may not uniquly identify an entity.but super key alwase.
that's why primary key is also called minimum superkey.
from
Rupesh
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |