Keys in DBMS | Primary Key, Foreign Key, Super Key, Candidate Key | DBMS Tutorial for Beginners 2023

Key plays an important role in DBMS and relational databases; it is used for identifying unique rows from tables. It also establishes relationships among tables. In this video, you will learn about the different types of keys in DBMS with examples and also understand what exactly are keys. The different types of keys in DBMS are − Candidate Key - The candidate keys in a table are defined as the set of keys that is minimal and can uniquely identify any data row in the table. Primary Key - The primary key is selected from one of the candidate keys and becomes the identifying key of a table. It can uniquely identify any data row in the table. Super Key - Super Key is the superset of the primary key. The super key contains a set of attributes, including the primary key, which can uniquely identify any data row in the table. Composite Key - If any single attribute of a table is not capable of being the key i.e it cannot identify a row uniquely, then we combine two or more attributes to form a key. This is known as a composite key. Secondary Key - Only one of the candidate keys is selected as the primary key. The rest of them are known as secondary keys. Foreign Key - A foreign key is an attribute value in a table that acts as the primary key in another table. Hence, the foreign key is useful in linking together two tables. Timestamps: 00:00 What are Keys in DBMS? 02:36 Types of Keys in DBMS 05:04 Super Key 06:20 Candidate Key 08:34 Primary Key 11:40 Composite Key 12:04 Foreign Key #primarykey #foreignkey #candidatekey #dbms #dbmscourse #keys #relationaldatabase #databasemanagement #databasemanagementsystem #codewithscaler #scaler Watch the full DBMS series: 🤍youtube.com/playlist?list=PL05sYGJyIXMrJDhsLnltf28jiHVEfRF9i Do Subscribe🧡so you don't miss all upcoming videos and lectures. These can indeed be gamechanger for your career and placement interviews! Also, Check out the Full Free JavaScript Course: 🤍youtube.com/playlist?list=PL05sYGJyIXMpH8cePGxHRp8aAJi1fdJdY Complete GitHub Actions - DevOps Series: 🤍youtube.com/playlist?list=PL05sYGJyIXMq7WIVzGa2vXHQ5mCXk2m2c