Тёмный

Alternate Key | Composite Key | DBMS 

making IT simple
Подписаться 16 тыс.
Просмотров 7 тыс.
50% 1

Alternate key is a key that has not been selected to be the primary key, but is a candidate key. combination of two or more attributes used to uniquely identify records in a relation or table is called as composite key. Watch the complete video to understand the concept completely.
Keys in DBMS | Playlist: • Types of Keys | DBMS
If you have not watched my previous videos on Database and DBMS concept click playlist link below:
Database and DBMS | Playlist: • Database & DBMS
Normalization in Database: • Normalization in DBMS ...
If you want to watch videos on operating system concepts use the links below:
Deadlock - Operating System | Playlist: • Deadlock - Operating S...
Process - Operating System | Playlist: • Process - Operating Sy...
Types of Operating System | Playlist: • Types of Operating Sys...
Other videos on the channel:
What is compiler?: • What is Compiler | Sho...
If you find my videos helpful and if the videos help in clearing your concepts, like the video, share it with your friends, subscribe the channel and press the bell icon. :)
#KeysinDBMS #AlternateKey #CompositeKey

Опубликовано:

 

26 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 10   
@I_veeresh
@I_veeresh 4 месяца назад
Your teaching skillls in too good
@makingITsimple1
@makingITsimple1 4 месяца назад
Thanks a lot
@spotlight4091
@spotlight4091 2 года назад
Bro now only I am watching ur videos.. Specially kinds of operating system.good explanation thank you for ur videos.. I request you to explain some important topics and put videos on the subject of Mobile Application Development MAD..
@solomonwoldetensay2047
@solomonwoldetensay2047 2 года назад
yes sir that is so True
@solomonwoldetensay2047
@solomonwoldetensay2047 2 года назад
Thank you for your videos bro
@bhagidasari9051
@bhagidasari9051 Год назад
Why can't we c take Roll_no and student_Name as composite key?
@anastastar
@anastastar Год назад
For example, we used Roll_No and Student_Name as a composite key: [4, D] [Operating system] [4, D] [Database] What can we see? [4, D] must be unique, but are the records above the same related to this composite key? No, 'cause one of them has [Operating system] as a subject name, and other has [Database], so this key is not unique. Thus, the best way will be using the Roll_No and Subject_Name as a composite key.
@nirajshah3412
@nirajshah3412 Год назад
Thanks 😊
@makingITsimple1
@makingITsimple1 Год назад
You're welcome!
@hemantkoranga6440
@hemantkoranga6440 Год назад
🎉
Далее
First Normal Form | Normalization | DBMS
7:03
Просмотров 9 тыс.
Keys in RDBMS
22:49
Просмотров 337 тыс.
Second Normal Form (2NF) | Normalization | DBMS
8:03
Functional Dependency in DBMS
8:14
Просмотров 56 тыс.
How do indexes make databases read faster?
23:25
Просмотров 66 тыс.