Smith and Kohli does not determine course exclusively, so is it mistake ?
@SaghirSchool4 күн бұрын
hi , at which time of video plz let me know so that i can asnwer it
@tsb_vlog113 күн бұрын
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.🙏🙏🙏
@victorberg92914 күн бұрын
How can it be in 2NF? What has name got to do this course?
@SaghirSchool14 күн бұрын
name of the teacher is related to the course he teaches , thats how
@SaghirSchool14 күн бұрын
i suggest watching the video again and even then u have any confusion plz let me know
@marthimallikarjun542717 күн бұрын
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!
@SaghirSchool17 күн бұрын
great , you can do a favor to me by sharing my channel to you friends
@IrfanComputerCollege22 күн бұрын
Sir bohat acha explain kia huwa hy aap NY thanks for such video
@SaghirSchool21 күн бұрын
@@IrfanComputerCollege plz share it with ur class and also let me know if u want a video on any other topic
@IrfanComputerCollege21 күн бұрын
@@SaghirSchool I am a teacher . I will recommend this lecture to students.
@IrfanComputerCollege21 күн бұрын
@@SaghirSchool I will tell you if there will be need of any viseo
@SaghirSchool21 күн бұрын
@@IrfanComputerCollege that you so much sir means a lot
@SaghirSchool21 күн бұрын
@@IrfanComputerCollege anytime
@Gausswn25 күн бұрын
well put
@life-os3qmАй бұрын
🤩tq sir
@FA-BCS-ALIRAZAUnknown2 ай бұрын
very good lecture
@tayyabali-jw6oh2 ай бұрын
love hogya
@mishusaeed2 ай бұрын
Easiest normalization video ever.
@vividhalade09922 ай бұрын
🥺kitne acchese samjhaya yaar🥺udemy k courses fail h is video k aage😊
@SaghirSchool2 ай бұрын
plz share with ur class
@kvelez2 ай бұрын
Thanks, please upload more.
@SaghirSchool2 ай бұрын
sure whct topics u want me to make videos on
@raunaktuladhar88262 ай бұрын
why Teacher 'G' teaches two subjects in 5:23? u can assign different value
@raihanakram5302 ай бұрын
Thank you very much! Best video for exam preparation with less time.
@teamit55382 ай бұрын
Thank you for your explanation sir! I hope I can ace my test tomorrow
@SaghirSchool2 ай бұрын
thank u so much , plewase share it woth the class as well tt llll be a favour to me
@AbhishekYadav-pv1es2 ай бұрын
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.7rambo6702 ай бұрын
perfect tutorial bro found it just before exam
@SaghirSchool2 ай бұрын
plz share it with ur fellows
@davidbrand16683 ай бұрын
Best explanation I’ve found on KZbin. Subbed. Thank you :)
@anandjoseph17323 ай бұрын
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???
@vinaydadi12973 ай бұрын
Write a query on each table
@narayanap-jz9gg3 ай бұрын
I heed one question please solve the answers question : input - a1bb2c3dd4e output - charnumcharcharnumcharnumcharcharnumchar please write the query answers
@abdullahriffat83553 ай бұрын
how is name dependent on both keys in 2nf
@chaithuchaitanya92733 ай бұрын
good exp
@galamdilliganesh50253 ай бұрын
Sir please do a video on BCNF please
@safuan99353 ай бұрын
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_3 ай бұрын
thank you so much, this was really helpful!!
@xiongbenjamin4 ай бұрын
clear and concise. Thank you!
@mrrelentless83394 ай бұрын
Amazing video
@tenebrae11914 ай бұрын
👏
@tenebrae11914 ай бұрын
👏
@AlumniAssociationFOLSGTU4 ай бұрын
HI SIR, YOU ARE SO GOOD. You explain this topic very well .
@chintusharma14 ай бұрын
🎉best video that a DBMS student need
@alamihanae87944 ай бұрын
A big thanks thanks to u sir
@raphgate14964 ай бұрын
Your tutorial is way clearer than some thousand dollar courses that I've seen online.
@SaghirSchool2 ай бұрын
plz share it with ur fellows
@MikeKm-hd1ve4 ай бұрын
Clear and concise! Thanks a lot! You should work on video flow a bit more, but the content is good
@DevOmar-id2ns5 ай бұрын
thank you so much very helpful❤❤❤❤
@architpuri68135 ай бұрын
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
@SaghirSchool5 ай бұрын
no it does not actually , bcz now its a linked table , and linked table has the liberty of that
@InsanWorrier5 ай бұрын
Best 🔥❤🔥
@xayrullayevzafar5 ай бұрын
Thank you
@pako45556 ай бұрын
What if the name column has similar name. isn't it best practice to use the primary key instead
@boitumeloirenenthake97226 ай бұрын
Nice explanation
@human25796 ай бұрын
SIMPLE, PERFECT AND CLEAR
@jasonxdmli44036 ай бұрын
sound absolutely ecstatic mate
@vagard16 ай бұрын
4:35 sorry, this is wrong. The attribute name written there is "Comment" not "ProductName". The correct query should be: WHERE Comment LIKE ..
@AliRaza-ei1mt6 ай бұрын
best video
@srh10346 ай бұрын
Did yourself get you just said?! kzbin.info/www/bejne/p2WngKypjJaLe9U
@sophanithphon7 ай бұрын
It is the best normal-form video explanation ever. I'm very appreciative.