Sir while u explain everything well some of the topics like tuple and domain calculus and inner join in relational algebra are missing also how to converter the model to a relational model. Plz add these sir it would help us a lot
Dear @Sparsh, if you are looking for complete detail & topics on DBMS, you can check out our complete DBMS course on the link given below: www.knowledgegate.in/learn/DBMSbysanchitsir
Noo, the attribute which you write after where clause should be the part of the attribute , here branch_name is not part of customer so can't access this attribute buddy!!
For complete DBMS, check out this video: ruclips.net/video/YRnjGeQbsHQ/видео.html
I was so confused about this topic, and after watching this video, my all doubts got cleared. !!!
Very good, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
Sir while u explain everything well some of the topics like tuple and domain calculus and inner join in relational algebra are missing also how to converter the model to a relational model. Plz add these sir it would help us a lot
Dear @Sparsh, if you are looking for complete detail & topics on DBMS, you can check out our complete DBMS course on the link given below:
www.knowledgegate.in/learn/DBMSbysanchitsir
ya aaj samaj me aaya......thanku sir
Best teacher and very easy explaining
Thank you sir... i understood it in one go
thank you very much sir for this video
sir on 8 53 i think you made mistake you told branch name north delhi but north delhi should be branch city not branch name
Thanks sir g
Sirji love you ❤
sir lekin borrower table me dipositor vale customer to nahi hoge to fir vo to chut jayenge to usake liye kya kare ??
Dhanyabad sir g
Sir now a days you aren't replying to any of the comments unlike before..
If Table1 has m rows and Table 2 has n rows, will the cartesian product of these two have m + n rows or m x n rows?
m + n
we will get m*n rows but m+n columns
thank you sir
You are most welcome! Keep learning & stay connected! You can also check out our website www.knowledgegate.in for more amazing videos & contents👍😊
thank you,sir
Correction : Cartesian product will give m*n tuples
he said columns
Yeah you're right but m+n columns he said.
Sir can we write like,.
Select cname from customer where branch_name IN (Select branch_name from branch where branch_name='ND')
Noo, the attribute which you write after where clause should be the part of the attribute , here branch_name is not part of customer so can't access this attribute buddy!!
thank u sir
Sir can you please upload video series about
Microprocessor 8085
watch this playlist on Microprocessor ruclips.net/p/PLS8ACsmFCpmQahmUVlcUYGUbqNd3usKct
But sir branch name are common for some account no
Dosto paper Download kese Karna h yaha se dekhe ..... Mene samjhane ki kosis ki h 👍👍👍 ruclips.net/video/AWEotINldIc/видео.html
Thanks sir