1NF 2NF 3NF DBMS

[@sprintspirit7502]

Best normalization tutorial on the internet. Short and accurate. Congratulations!!!

[@SaghirSchool]

thank consider subscribing and also sharing it as well thank you

[@itstahaali]

looks like sponsored comment lol

[@sprintspirit7502]

@@itstahaali Myb looks but it is not ;)

[@raphgate1496]

Your tutorial is way clearer than some thousand dollar courses that I've seen online.

[@SaghirSchool]

plz share it with ur fellows

[@sujalpardasani3199]

Normalization is just fitted in my mind with this video,i was very confused between 2nf and 3nf ....thankyou sir for the best video

[@daphneysethe7562]

The best Tutor I ever met who made me understand Normalisation within a period of 10 minutes wow. Good job🥰🥰🥰 I am repeating this module as supplementary but I'm telling you with your tutorial lessons il make it 🤗

[@spokenenglishmentsbd9998]

Well explained. Crystal clear normalization lecture ever. Lots of love from Bangladesh.

[@sophanithphon]

It is the best normal-form video explanation ever. I'm very appreciative.

[@zainali-pm1mn]

very well explained. I had no issue while understanding it. Thank you so much sir

[@SaghirSchool]

i m glad you liked it,Kindly share my channel , that ll be a big support

[@fgskills797]

Bhai kasam say dil khush kar diya itnay mazay ka samjhaya aap nay...salaamat rahen or khub taraqi karen ameen

[@SaghirSchool]

plz share karain isy , will be grear help

[@claytondunaway]

Fantastic examples to help me understand normalization! Thank you!

[@tsb_vlog1]

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.🙏🙏🙏

[@muhammadabatchamustapha8461]

You explained everything so well, anyone can understand you the best 😃😃😃

[@raihanakram530]

Thank you very much! Best video for exam preparation with less time.

[@Dm5messerly]

Really clear and concise. The examples provided made everything so clear.

[@johna4387]

Super clear explanation, thank you so much!

[@fortunemakgakga4547]

Thanks dude, I loved how you explained 2NF and 3NF, clear enough

[@dominicrono9632]

thumbs up for the good simplified work.

[@enderesting]

in 4:55, wouldn't Name be partially dependent to the composite key as well? it does not depend on Course, just the StudentId.

[@elaf7092]

same question

[@theslaye2160]

@@elaf7092 its not partially dependent coz you need to know the student thats taking that course

[@sivaprasanthmasilamani8752]

That's not true. You only need to know the studentid to know the name. So in practice, I would create a new table called Student with student id as primary key and student name as non-key column

[@carltechnologies9888]

Thanks a lot, I've been looking for this kind of tutorial, you saved my life brother.. Thank you....

[@human2579]

SIMPLE, PERFECT AND CLEAR

[@AsadAliJatoi01]

Kindly make BCNF video as well.

[@SaghirSchool]

sure my friend will work on it this week,also please share my channel

[@superrukhshan12345]

Brilliant explanation.

[@umairawan658]

Great vid cleared my concepts regarding NFs on which I was struggling

[@Subha11.11]

Great explanation, keep up the great work 👍🏻

[@AlumniAssociationFOLSGTU]

HI SIR, YOU ARE SO GOOD. You explain this topic very well .

[@Roboytron]

Thank you, my teacher is very hard to understand and made these seem so much harder lol.

[@sureshgandhi3918]

great explanation. I have a doubt though. At 5:26 can't we separate the name column together with student id in a separate table. Isn't student name dependent on just student id but not the course?

[@SaghirSchool]

Thank u , but then again student id is the part of primary key , so we cant disturb that part on the other hand teacher and course are not part of primary ,thats why we can move them , if you ve liked the video please d me a favor and share it wherever you can

[@fli4343]

the students still enroll in a course so that means the student is dependent on the student ID and course.

[@thamizhansudip6644]

@@fli4343 Yes , of course

[@Rainie45]

@@SaghirSchool how is course not part of the primary key?

[@052khandkermoniruzzaman7]

exactly is'nt name is partily dependent on student id only. so name should also be separated

[@MrKB_SSJ2]

Very well explained. Thank you ❤️

[@sathish3618]

wow amazing clear explanation after searching so many videos..

[@TimeouT-lm1fw]

I didn't know where to start from till I saw this happy I clicked this

[@younus.athlete]

Sir ! Thank you so much for Uploading this Video this Video Clear My all concepts

[@younus.athlete]

Slides are Organized and all Video are to the Point thats really nice

[@chintusharma1]

🎉best video that a DBMS student need

[@mannaoleeviya3717]

Not too lengthy but still concept is well explained. Thanku Sagir.

[@amt.7rambo670]

perfect tutorial bro found it just before exam

[@SaghirSchool]

plz share it with ur fellows

[@AbhishekYadav-pv1es]

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).

[@pannaroy6569]

But in d example for 3rd NF , max marks is dependent on exam type ...not student id ...means maxmarks is not fully functional dependent on primary key(which is student id) ...so it seems like d case of 2nd normal form only

[@winfredkimathi9]

the best among those that have come across

[@isaacwolf4969]

Thanks Saghir, liked subbed and shared, much better than my prof!!

[@manashejmadi]

fantastic explanation. Thanks

[@vemulasoumyasri830]

Nyc explained sir thank you sir...

[@abdulwasybutt9006]

Thank you sir you clear all my doubts🙂

[@cepheusff4876]

Great bro.....I have watched more than 10 videos but I can't understand normalisation......you got that in 10mins✌️❤️

[@suprajaiyer2000]

Nicely explained thank you❤

[@SaghirSchool]

was it helpfull?

[@suprajaiyer2000]

@@SaghirSchool yess

[@vinaymedasani2386]

Very well explained !! @Saghir School

[@ramans11]

Very nice.. excellent explanation.. just correct the typos in your slides

[@PulengMakumane-rn5rh]

This is very clear thank you😊❤

[@sakshamdogra]

Thank you so much sir. Much love ❤

[@FA-BCS-ALIRAZAUnknown]

very good lecture

[@tayyabali-jw6oh]

love hogya

[@architpuri6813]

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]

no it does not actually , bcz now its a linked table , and linked table has the liberty of that

[@KhoaNguyen-nt5cn]

Absolutely understand that. BIG THANKS

[@tanmaymehta9696]

Thank you so much for this video!

[@nayana3718]

Good bro good content sure I will share ur videos

[@SaghirSchool]

do me a favour, kindly share this whereever possible,will be a real help

[@muhammadabatchamustapha8461]

Thank you so much for this video 1 day to my exams

[@SaghirSchool]

thank consider subscribing and also sharing it as well thank you

[@InsanWorrier]

Best 🔥❤‍🔥

[@ajitkc6862]

Good be your 100th subscriber. Very helpful content. Best wishes 👏

[@SaghirSchool]

Well appreciated thanks, i ll be makimg more content soon thanks for the support

[@SaghirSchool]

Kindly share my channel , that ll be a big support

[@soobii00]

you're so amazing !! life saver

[@prasadzanje7026]

4.58 Sir, If student ID is primary key , then it's must be follow rules of primary key. 201 and 205 violtes rules ( Each row having unique value ).

[@KanzaIltaf]

and name is also partially dependent bcz it can be determined by std_id.

[@safuan9935]

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?

[@JavaScriptYatra]

too good brother. Thank you for this video!

[@raunaktuladhar8826]

why Teacher 'G' teaches two subjects in 5:23? u can assign different value

[@beingbenji09]

@Saghir, if a column is primary key by default you cannot have redundant data. So having 201 twice isnt possible

[@bhanuprakash6915]

It is possible if we have to display marks of 2 subjects in one table

[@manzarali3599]

Understood clearly ❤

[@MuhammadUmair-vd6fx]

Well explained the topic

[@EfilWarlord]

min 5:30,it still doesnt pass 2NF because Name depends only on studentID and has nothing to do with the course coloumn, correct?

[@ruchilawijerathne1304]

I had the same thought

[@Gausswn]

well put

[@FahmiEshaq]

Well explained...

[@SaghirSchool]

thank consider subscribing and also sharing it as well thank you

[@AliRaza-ei1mt]

best video

[@kenzoken7543]

thanks for this video man.

[@mishusaeed]

Easiest normalization video ever.

[@jigarkathiriya66]

In the 2nf that you have described.......why only teacher is partially dependent while student_name also only depend on Id i.e student_name nothing to do with course name...Id is enough to identify student....can we remove that column ??????

[@hemanthmb7842]

Yes you are correct.

[@ahmedalikhan3991]

Yep in this case , the marks should be separated

[@kuheli3250]

What I think is, if someone is a student then he must have any course, otherwise his name doesn't have any purpose to get enlisted in this table, and hence s.name depends on course name too.

[@sushilgyawali7880]

thank you

[@dattabadhe6759]

Worth watching

[@user-tk2xk6uh1j]

super

[@victorberg929]

How can it be in 2NF? What has name got to do this course?

[@SaghirSchool]

name of the teacher is related to the course he teaches , thats how

[@SaghirSchool]

i suggest watching the video again and even then u have any confusion plz let me know

[@channuangadi8506]

Osm

[@suvamroy6205]

Just awesome!!!

[@vanshshah6418]

thanks a lot nice explation

[@codewithwaqas5862]

Thank you sir

[@code2287]

Am a bit confused in the student ID primary key(201)..I thought primary key columns can't have repeating rows...and 201 appeared twice am not a pro so if this question sounds silly, please bear with me😊

[@SaghirSchool]

you must be talking about the 2nf part , its a different thing all together where there is a need of more than one primary key combinations to make it primary , in that one column can repeat itself but but the combination of columns which is unique and giving it the difference factor, there is a same video made on this in hindi as well if u want it so

[@suprajaiyer2000]

@@SaghirSchool can u explain more clearly to that question pls

[@SaghirSchool]

@@suprajaiyer2000 sure, what u need to know more about it?

[@suprajaiyer2000]

@@SaghirSchool answer for the same question how two primary keys

[@SaghirSchool]

@@suprajaiyer2000 there can be a situation where we need more than one primary key column if we know that there is a possibility of repetition of a value in a column then combination of two columns are taken as primary , if we r certain that the combination of two columns is totally unique then problem solved and keep in mind there can be more than two primary columns as well

[@dineshi3971]

in 2NF, Name is just dependent on studentID alone, right, which is partial dependency? it should also have been removed right

[@SaghirSchool]

no its not like that, name is a part of primary key , here name and id the combination is primary key , so the name is exemt from this

[@sanjaymamidipaka3546]

@@SaghirSchool how is it part of the primary key? you said the composite key was the studentid and course, right?

[@gailwy]

@@SaghirSchool I think they mean that in the 2NF example. the non-key column "Name" is dependent on only the Primary Key "StudentId". Since "Name" isn't dependent on the Key column "course", shouldn't name also be removed and made into a seperate table?

[@GarlapatiBhoomikareddy-zo9vt]

Hi How can we join the table in 1st NF without mentioning the candidate key in phone table?

[@abdullahriffat8355]

how is name dependent on both keys in 2nf

[@jumajuma9311]

best explanation

[@TimeouT-lm1fw]

This is awesome bro wtf

[@praiseofume]

this really helped alot. Thank you

[@chaithuchaitanya9273]

good exp

[@pratheekhebbar2677]

explained soo clearly

[@iiiblanklll6651]

Thanks :)

[@adeyas4989]

Wow

[@Hiwa754]

very helpful

[@kevincudjoe9259]

in the 2NF student ID is dependent on the student name which is part of the composite key

[@SaghirSchool]

composite key is when there is a need of more than one column s combination to be unique,here id and course is repeatable but not the combination of both , so this combination is the composite key here

[@stijojoseph7156]

@@SaghirSchool Dude even in the new table which u have formed for 2NF is not deprived partial dependency See partial dependency means if part of your candidate key within a composite key is functionally dependent on any NON-prime attribute its not in 2nf. Here SID+Course is the composite key , SID functionally dependent on Name and Also Course is functionallly dependent on Teacher ,So there is two partial dependencies but you have solved to remove one partail dependency only i will descibe below how it should may be helpful for some people - studentid which has partial dependency on name hence its not still in 2nF, You should have divided it into 3 tables to make it deprived of 2nf like Table1-SID,NAME Table2-Course,Teacher Table3-SID,Course,Marks now only its in 2NF

[@tenebrae1191]

👏

[@amoghpanday4145]

Simple and fast

[@LaXuyt333]

If there is Std Id. Std name prof Id Prof Name and Grade table What will be it's 2nf

[@feddylacabra254]

Just wow🎉🎉🎉🎉🫡

[@narayanap-jz9gg]

I heed one question please solve the answers question : input - a1bb2c3dd4e output - charnumcharcharnumcharnumcharcharnumchar please write the query answers

[@johnsamuellawrence]

Your 1NF is wrong, i guess...there can be many people with the same name, so the second table should have the emp_Id and the phone number

[@raaghavshiiwakoty]

Wauuuuuuu

[@interviewblast3055]

great