Ad Code

Super Key Vs Super Key

Reference to Super Key, I made three attributes as super key which are Student Name, Student ID, and Student Address. Can we say just two attributes are also super key? Can we say that student name and student id both are jointly as super key ? Kindly explain in detail by taking one more example.



As we know that any combination of attributes with the super key is also a super key. Yes, if you make super key of just two attributes of your choice like "Student ID, Student Address" then this combination of two attributes will also be a super key.

Example:
              Suppose we have an Entity Type EMPLOYEE having attributes Emp ID, Name, Address, Salary, Commission, Joining Date, Designation etc. Now here we suppose "Emp ID" as super key, now if we consider any combination of Emp ID with any other attribute of EMPLOYEE entity type, the combination will also be a super key. For example, "Emp ID, Name", "Emp ID, Name, Address" and "Joining Date, Emp ID" and many others all are super keys.
Reactions

Post a Comment

0 Comments