What do you mean by super key, primary key, foreign key and candidate key?
- Super Key:- This key recognizes the row in the table.
- Primary Key:-This key is a column in the table which recognizes each row in the same table uniquely
- Candidate Key:-This key does not have any repeated attribute
- Foreign Key:-This key a column in the table to create a relationship with another table.
This particular RDBMS Question explains the importance of keys in the database.