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 🤗
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
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?
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
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
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
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).
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 ??????
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.
@@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?
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😊
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 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
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
@@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
Best normalization tutorial on the internet.
Short and accurate.
Congratulations!!!
thank consider subscribing and also sharing it as well thank you
looks like sponsored comment lol
@@itstahaali Myb looks but it is not ;)
Fantastic examples to help me understand normalization! Thank you!
Thanks dude, I loved how you explained 2NF and 3NF, clear enough
Your tutorial is way clearer than some thousand dollar courses that I've seen online.
plz share it with ur fellows
Really clear and concise. The examples provided made everything so clear.
Super clear explanation, thank you so much!
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 🤗
It is the best normal-form video explanation ever. I'm very appreciative.
Great explanation, keep up the great work 👍🏻
Well explained. Crystal clear normalization lecture ever. Lots of love from Bangladesh.
Normalization is just fitted in my mind with this video,i was very confused between 2nf and 3nf ....thankyou sir for the best video
thumbs up for the good simplified work.
Great vid cleared my concepts regarding NFs on which I was struggling
You explained everything so well, anyone can understand you the best 😃😃😃
Thanks a lot, I've been looking for this kind of tutorial, you saved my life brother..
Thank you....
Very well explained. Thank you ❤️
very well explained. I had no issue while understanding it. Thank you so much sir
i m glad you liked it,Kindly share my channel , that ll be a big support
Thank you so much sir. Much love ❤
too good brother. Thank you for this video!
Thank you, my teacher is very hard to understand and made these seem so much harder lol.
Thank you very much! Best video for exam preparation with less time.
Slides are Organized and all Video are to the Point
thats really nice
in 4:55, wouldn't Name be partially dependent to the composite key as well? it does not depend on Course, just the StudentId.
same question
@@elaf7092 its not partially dependent coz you need to know the student thats taking that course
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
Brilliant explanation.
SIMPLE, PERFECT AND CLEAR
Absolutely understand that. BIG THANKS
Thank you so much for this video!
wow amazing clear explanation after searching so many videos..
This is very clear thank you😊❤
the best among those that have come across
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?
🎉best video that a DBMS student need
Thanks Saghir,
liked subbed and shared,
much better than my prof!!
you're so amazing !! life saver
fantastic explanation. Thanks
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?
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
the students still enroll in a course so that means the student is dependent on the student ID and course.
@@fli4343 Yes , of course
@@SaghirSchool how is course not part of the primary key?
exactly is'nt name is partily dependent on student id only. so name should also be separated
thanks for this video man.
Great bro.....I have watched more than 10 videos but I can't understand normalisation......you got that in 10mins✌️❤️
Kindly make BCNF video as well.
sure my friend will work on it this week,also please share my channel
Good bro good content sure I will share ur videos
do me a favour, kindly share this whereever possible,will be a real help
Sir ! Thank you so much for Uploading this Video this Video Clear My all concepts
This is awesome bro wtf
Not too lengthy but still concept is well explained. Thanku Sagir.
Thank you sir you clear all my doubts🙂
Nicely explained thank you❤
was it helpfull?
@@SaghirSchool yess
Bhai kasam say dil khush kar diya itnay mazay ka samjhaya aap nay...salaamat rahen or khub taraqi karen ameen
plz share karain isy , will be grear help
Good be your 100th subscriber. Very helpful content. Best wishes 👏
Well appreciated thanks, i ll be makimg more content soon thanks for the support
Kindly share my channel , that ll be a big support
Hi
How can we join the table in 1st NF without mentioning the candidate key in phone table?
I didn't know where to start from till I saw this happy I clicked this
HI SIR, YOU ARE SO GOOD. You explain this topic very well .
Thank you so much for this video 1 day to my exams
thank consider subscribing and also sharing it as well thank you
how is name dependent on both keys in 2nf
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
Understood clearly ❤
Just awesome!!!
Worth watching
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
no it does not actually , bcz now its a linked table , and linked table has the liberty of that
Well explained the topic
Very nice.. excellent explanation.. just correct the typos in your slides
min 5:30,it still doesnt pass 2NF because Name depends only on studentID and has nothing to do with the course coloumn, correct?
I had the same thought
perfect tutorial bro found it just before exam
plz share it with ur fellows
why Teacher 'G' teaches two subjects in 5:23? u can assign different value
Thank you sir
Nyc explained sir thank you sir...
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).
@Saghir, if a column is primary key by default you cannot have redundant data. So having 201 twice isnt possible
It is possible if we have to display marks of 2 subjects in one table
Very well explained !!
@Saghir School
very helpful
this really helped alot. Thank you
explained soo clearly
thanks a lot nice explation
Best 🔥❤🔥
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 ??????
Yes you are correct.
Yep in this case , the marks should be separated
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.
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 ).
and name is also partially dependent bcz it can be determined by std_id.
thank you
Thanks :)
best explanation
in 2NF, Name is just dependent on studentID alone, right, which is partial dependency? it should also have been removed right
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
@@SaghirSchool how is it part of the primary key? you said the composite key was the studentid and course, right?
@@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?
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😊
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
@@SaghirSchool can u explain more clearly to that question pls
@@suprajaiyer2000 sure, what u need to know more about it?
@@SaghirSchool answer for the same question how two primary keys
@@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
best video
Simple and fast
Well explained...
thank consider subscribing and also sharing it as well thank you
super
Osm
love hogya
very good lecture
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
Wow
Easiest normalization video ever.
If there is Std Id. Std name prof Id Prof Name and Grade table
What will be it's 2nf
👏
good exp
in the 2NF student ID is dependent on the student name which is part of the composite key
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
@@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
Wauuuuuuu
Just wow🎉🎉🎉🎉🫡
I heed one question please solve the answers question : input - a1bb2c3dd4e output - charnumcharcharnumcharnumcharcharnumchar
please write the query answers
great
instagram.com/_saghir/ follow me there plz
No goog
what