Lec- 2: Types of keys in database design | Tables in DBMS | Keys in DBMS | Beginners Tutorial
Hey There Dev Champ, This is the 2nd time we are sitting together to discuss Relational Database Management System
Previously we compared the Relational Database Management System and Non-Relational Database Management System.
In this video, Question answered:
What is a Table in Relational Database Management System?
What is a Key in RDBMS?
what are the different types of keys in RDBMS and when are they used?
Question answered:
what is tuple in dbms ?
Difference between primary key and candidate key ?
what is candidate key in dbms ?
concept of keys in dbms
how many types of keys in database design?
Using animated doodles, illustrations, animated explainer videos and engaging figures.
Row is also known as "Tuple" …
where the term "attribute" is used for a column …
and a table is also called "Relation"…
In a relational database keys are used to create a connection between different relations i.e. tables.
There are multiple Types of Keys, such as
Super Key in dbms
Primary Key in dbms
Candidate Key in dbms
Alternate Key or Secondary Key in dbms
Foreign Key in dbms
Composite Key in dbms
Compound Key in dbms
And Surrogate key in dbms
Lec- 2: Types of Keys in DBMS | Tables in DBMS | Keys in DBMS | Beginners Tutorial
Top Moments in this Lecture:
0:18 Link of Previous Lecture
0:24 Topics Covered in this Lecture
0:47 Tables in Database
1:02 Use of Keys in a Relational Database
1:17 What is Tuple, Attribute and Relation in a Database
2:50 What is a Key in Database?
2:56 Types of Keys in Database
3:22 Super Key
3:40Primary Key
4:18 Candidate Key
4:47 Alternate Key or Secondary Key
5:18 Foreign Key
6:11 Composite Key
6:41 Compound Key
7:05 Surrogate Key
►************* Important Links *********
1. • Lec- 1: Database Types | Difference relati...
2. • Software Development overview for beginner...
►************* For Business ************
Please email at : [email protected]
#keysindbms #beginnerstutorial #tablesindbms #databasemanagementsystem #dbmstutorials #differenttypesofkeysindbms #typesofkeysindbms #dbmskeys #keysdbms #allkeysindbms