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
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).
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
@@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?
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
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.
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
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 ;)
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 🤗
Fantastic examples to help me understand normalization! Thank you!
Thanks dude, I loved how you explained 2NF and 3NF, clear enough
Really clear and concise. The examples provided made everything so clear.
Your tutorial is way clearer than some thousand dollar courses that I've seen online.
plz share it with ur fellows
Super clear explanation, thank you so much!
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
Great explanation, keep up the great work 👍🏻
It is the best normal-form video explanation ever. I'm very appreciative.
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....
Great vid cleared my concepts regarding NFs on which I was struggling
how is name dependent on both keys in 2nf
Brilliant explanation.
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
thumbs up for the good simplified work.
wow amazing clear explanation after searching so many videos..
Very well explained. Thank you ❤️
This is very clear thank you😊❤
Thank you so much for this video!
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?
Thank you very much! Best video for exam preparation with less time.
Thank you, my teacher is very hard to understand and made these seem so much harder lol.
too good brother. Thank you for this video!
Thank you so much sir. Much love ❤
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
Absolutely understand that. BIG THANKS
Thanks Saghir,
liked subbed and shared,
much better than my prof!!
Slides are Organized and all Video are to the Point
thats really nice
Hi
How can we join the table in 1st NF without mentioning the candidate key in phone table?
fantastic explanation. Thanks
SIMPLE, PERFECT AND CLEAR
thanks for this video man.
you're so amazing !! life saver
Not too lengthy but still concept is well explained. Thanku Sagir.
Sir ! Thank you so much for Uploading this Video this Video Clear My all concepts
the best among those that have come across
Great bro.....I have watched more than 10 videos but I can't understand normalisation......you got that in 10mins✌️❤️
Thank you sir you clear all my doubts🙂
🎉best video that a DBMS student need
HI SIR, YOU ARE SO GOOD. You explain this topic very well .
Just awesome!!!
Kindly make BCNF video as well.
sure my friend will work on it this week,also please share my channel
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
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
Good bro good content sure I will share ur videos
do me a favour, kindly share this whereever possible,will be a real help
Understood clearly ❤
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
This is awesome bro wtf
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
Worth watching
Best 🔥❤🔥
Nicely explained thank you❤
was it helpfull?
@@SaghirSchool yess
why Teacher 'G' teaches two subjects in 5:23? u can assign different value
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).
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
Thank you so much for this video 1 day to my exams
thank consider subscribing and also sharing it as well thank you
thanks a lot nice explation
Very nice.. excellent explanation.. just correct the typos in your slides
Well explained the topic
very helpful
thank you
Nyc explained sir thank you sir...
@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
perfect tutorial bro found it just before exam
plz share it with ur fellows
Thank you sir
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
explained soo clearly
best explanation
Very well explained !!
@Saghir School
Thanks :)
best video
well put
I didn't know where to start from till I saw this happy I clicked this
super
this really helped alot. Thank you
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?
👏
Well explained...
thank consider subscribing and also sharing it as well thank you
Wow
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.
love hogya
very good lecture
Simple and fast
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
Osm
good exp
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.
Easiest normalization video ever.
If there is Std Id. Std name prof Id Prof Name and Grade table
What will be it's 2nf
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
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
Just wow🎉🎉🎉🎉🫡
great
instagram.com/_saghir/ follow me there plz
No goog
what
I heed one question please solve the answers question : input - a1bb2c3dd4e output - charnumcharcharnumcharnumcharcharnumchar
please write the query answers