Keys in DBMS
881747Aug 11 2011 — edited Aug 11 2011Hi, this is Khalid. I am new in DBMS. I have just started to study. I am having a little bit confusion in the Concept of Keys of DBMS and Attributes. So, I am getting little bit problem to understand the concept of Keys. Somebody, please help me.
Now, i am just going to show a Relation.
Employee EMP_ID EMP_NAME EMP_SALARY
-------- -------------- ----------
101 Khalid 17000
102 Rajib 16000
103 Rahul 18000
104 Dibakar 17000
105 Akikul 16000
106 Bidyut 16500
107 Pranjal 16500
Somebody is saying that the rows or the tuples within the table are the Keys, whereas somebody's opinion is is the Column Title. So, i am in the confusion that if the column name is the key value, then what is an attribute ? Please explain the very basic concept of every type of Keys. Such as Super Key, Primery Key, Candidate Key, Foreign Key etc.
So, please help me. This is the very first time in any kind of forum. So, I politely request you everybody to give me a proper solution for my problem. Thanks.