Primary & Foreign Key in Database
6:04
Boyce Codd Normal Form BCNF  Database
3:56
Decimal to Octal conversion in Hindi
4:24
1NF 2NF 3NF DBMS
8:32
4 жыл бұрын
Пікірлер
@user-bj1cb5kv8l
@user-bj1cb5kv8l 2 күн бұрын
Thomas Susan Jackson Richard Garcia Mark
@SaghirSchool
@SaghirSchool 2 күн бұрын
@@user-bj1cb5kv8l interesting connent brother
@muneeburrehman8649
@muneeburrehman8649 4 күн бұрын
Smith and Kohli does not determine course exclusively, so is it mistake ?
@SaghirSchool
@SaghirSchool 4 күн бұрын
hi , at which time of video plz let me know so that i can asnwer it
@tsb_vlog1
@tsb_vlog1 13 күн бұрын
Great explanation , you just cleared my all doubts bcoz sometimes I usually make mistake this table normal form consept with numerical functional dependency NF problems . Thanks for this video.🙏🙏🙏
@victorberg929
@victorberg929 14 күн бұрын
How can it be in 2NF? What has name got to do this course?
@SaghirSchool
@SaghirSchool 14 күн бұрын
name of the teacher is related to the course he teaches , thats how
@SaghirSchool
@SaghirSchool 14 күн бұрын
i suggest watching the video again and even then u have any confusion plz let me know
@marthimallikarjun5427
@marthimallikarjun5427 17 күн бұрын
Thanks a ton i understood those dependencies earlier but didn't know how to solve them now I have clear cut vision of wt to do!
@SaghirSchool
@SaghirSchool 17 күн бұрын
great , you can do a favor to me by sharing my channel to you friends
@IrfanComputerCollege
@IrfanComputerCollege 22 күн бұрын
Sir bohat acha explain kia huwa hy aap NY thanks for such video
@SaghirSchool
@SaghirSchool 21 күн бұрын
@@IrfanComputerCollege plz share it with ur class and also let me know if u want a video on any other topic
@IrfanComputerCollege
@IrfanComputerCollege 21 күн бұрын
@@SaghirSchool I am a teacher . I will recommend this lecture to students.
@IrfanComputerCollege
@IrfanComputerCollege 21 күн бұрын
@@SaghirSchool I will tell you if there will be need of any viseo
@SaghirSchool
@SaghirSchool 21 күн бұрын
@@IrfanComputerCollege that you so much sir means a lot
@SaghirSchool
@SaghirSchool 21 күн бұрын
@@IrfanComputerCollege anytime
@Gausswn
@Gausswn 25 күн бұрын
well put
@life-os3qm
@life-os3qm Ай бұрын
🤩tq sir
@FA-BCS-ALIRAZAUnknown
@FA-BCS-ALIRAZAUnknown 2 ай бұрын
very good lecture
@tayyabali-jw6oh
@tayyabali-jw6oh 2 ай бұрын
love hogya
@mishusaeed
@mishusaeed 2 ай бұрын
Easiest normalization video ever.
@vividhalade0992
@vividhalade0992 2 ай бұрын
🥺kitne acchese samjhaya yaar🥺udemy k courses fail h is video k aage😊
@SaghirSchool
@SaghirSchool 2 ай бұрын
plz share with ur class
@kvelez
@kvelez 2 ай бұрын
Thanks, please upload more.
@SaghirSchool
@SaghirSchool 2 ай бұрын
sure whct topics u want me to make videos on
@raunaktuladhar8826
@raunaktuladhar8826 2 ай бұрын
why Teacher 'G' teaches two subjects in 5:23? u can assign different value
@raihanakram530
@raihanakram530 2 ай бұрын
Thank you very much! Best video for exam preparation with less time.
@teamit5538
@teamit5538 2 ай бұрын
Thank you for your explanation sir! I hope I can ace my test tomorrow
@SaghirSchool
@SaghirSchool 2 ай бұрын
thank u so much , plewase share it woth the class as well tt llll be a favour to me
@AbhishekYadav-pv1es
@AbhishekYadav-pv1es 2 ай бұрын
in 2NF you have set Primary key to two fields(columns) which is not possible in ms access because a primary can only have unique values and not repeating values, and it cannot have null(empty) values as well. in MS access both two columns cannot have primary key, and a value that repeats (in a column).
@amt.7rambo670
@amt.7rambo670 2 ай бұрын
perfect tutorial bro found it just before exam
@SaghirSchool
@SaghirSchool 2 ай бұрын
plz share it with ur fellows
@davidbrand1668
@davidbrand1668 3 ай бұрын
Best explanation I’ve found on KZbin. Subbed. Thank you :)
@anandjoseph1732
@anandjoseph1732 3 ай бұрын
In many to many relationship we created a new linking table.Now both author table and book table contain any of of the information of the other table.So how can we connect both table without the any of the information???
@vinaydadi1297
@vinaydadi1297 3 ай бұрын
Write a query on each table
@narayanap-jz9gg
@narayanap-jz9gg 3 ай бұрын
I heed one question please solve the answers question : input - a1bb2c3dd4e output - charnumcharcharnumcharnumcharcharnumchar please write the query answers
@abdullahriffat8355
@abdullahriffat8355 3 ай бұрын
how is name dependent on both keys in 2nf
@chaithuchaitanya9273
@chaithuchaitanya9273 3 ай бұрын
good exp
@galamdilliganesh5025
@galamdilliganesh5025 3 ай бұрын
Sir please do a video on BCNF please
@safuan9935
@safuan9935 3 ай бұрын
I don't see any 2nd normal form in your example of 3rd normal. In the vid, u say that it must be in 2 nd normal form before proceeding with 3rd right?
@thisrandomdude_
@thisrandomdude_ 3 ай бұрын
thank you so much, this was really helpful!!
@xiongbenjamin
@xiongbenjamin 4 ай бұрын
clear and concise. Thank you!
@mrrelentless8339
@mrrelentless8339 4 ай бұрын
Amazing video
@tenebrae1191
@tenebrae1191 4 ай бұрын
👏
@tenebrae1191
@tenebrae1191 4 ай бұрын
👏
@AlumniAssociationFOLSGTU
@AlumniAssociationFOLSGTU 4 ай бұрын
HI SIR, YOU ARE SO GOOD. You explain this topic very well .
@chintusharma1
@chintusharma1 4 ай бұрын
🎉best video that a DBMS student need
@alamihanae8794
@alamihanae8794 4 ай бұрын
A big thanks thanks to u sir
@raphgate1496
@raphgate1496 4 ай бұрын
Your tutorial is way clearer than some thousand dollar courses that I've seen online.
@SaghirSchool
@SaghirSchool 2 ай бұрын
plz share it with ur fellows
@MikeKm-hd1ve
@MikeKm-hd1ve 4 ай бұрын
Clear and concise! Thanks a lot! You should work on video flow a bit more, but the content is good
@DevOmar-id2ns
@DevOmar-id2ns 5 ай бұрын
thank you so much very helpful❤❤❤❤
@architpuri6813
@architpuri6813 5 ай бұрын
Doesn't the new table created at 2:50 also violate 1NF though? Because of the repeating names? I personally thought it should be a table consisting of employeeID linked with phone numbers, but I'm not sure, could be wrong
@SaghirSchool
@SaghirSchool 5 ай бұрын
no it does not actually , bcz now its a linked table , and linked table has the liberty of that
@InsanWorrier
@InsanWorrier 5 ай бұрын
Best 🔥❤‍🔥
@xayrullayevzafar
@xayrullayevzafar 5 ай бұрын
Thank you
@pako4555
@pako4555 6 ай бұрын
What if the name column has similar name. isn't it best practice to use the primary key instead
@boitumeloirenenthake9722
@boitumeloirenenthake9722 6 ай бұрын
Nice explanation
@human2579
@human2579 6 ай бұрын
SIMPLE, PERFECT AND CLEAR
@jasonxdmli4403
@jasonxdmli4403 6 ай бұрын
sound absolutely ecstatic mate
@vagard1
@vagard1 6 ай бұрын
4:35 sorry, this is wrong. The attribute name written there is "Comment" not "ProductName". The correct query should be: WHERE Comment LIKE ..
@AliRaza-ei1mt
@AliRaza-ei1mt 6 ай бұрын
best video
@srh1034
@srh1034 6 ай бұрын
Did yourself get you just said?! kzbin.info/www/bejne/p2WngKypjJaLe9U
@sophanithphon
@sophanithphon 7 ай бұрын
It is the best normal-form video explanation ever. I'm very appreciative.
@ahmedali3017
@ahmedali3017 7 ай бұрын
Excellent sir.
@user-tk2xk6uh1j
@user-tk2xk6uh1j 7 ай бұрын
super