- Видео 47
- Просмотров 517 022
Saghir School
Пакистан
Добавлен 23 апр 2020
My mission is to make everything Computer Science and Tech, easily accessible and completely free for everyone.
As a University-level teacher, my experiences have sparked a passion in me to use more creative methods to make education more fun and simple so my students can make the most out of it.
I want to do what I can to teach more and more people that Computer Science is fun and that anyone can get into the industry with a little hard work and just the right strategies.
Subscribe today to support free education for all
As a University-level teacher, my experiences have sparked a passion in me to use more creative methods to make education more fun and simple so my students can make the most out of it.
I want to do what I can to teach more and more people that Computer Science is fun and that anyone can get into the industry with a little hard work and just the right strategies.
Subscribe today to support free education for all
All Normal Forms | 1NF 2NF 3NF BCNF 4NF 5NF with examples
All Normal Forms | 1NF 2NF 3NF BCNF 4NF 5NF with examples
Chapters:
00:02 First Normal Form
01:46 Understanding Composite Keys 🔑
03:41 Exploring Partial Dependency 🔗
04:27 Third Normal Form 🚀
04:56 Transitive Dependency Explained in 3NF
07:14 BCNF
10:30 4NF
15:07 5NF
Chapters:
00:02 First Normal Form
01:46 Understanding Composite Keys 🔑
03:41 Exploring Partial Dependency 🔗
04:27 Third Normal Form 🚀
04:56 Transitive Dependency Explained in 3NF
07:14 BCNF
10:30 4NF
15:07 5NF
Просмотров: 46
Видео
5th Normal Form 5NF HINDI Join Dependency Database
Просмотров 64 часа назад
5th Normal Form 5NF HINDI Join Dependency Database
5th Normal Form 5NF Join Dependency Database
Просмотров 64 часа назад
5th Normal Form 5NF Join Dependency Database
4th Normal Form 4NF , HINDI Database Normalization
Просмотров 34 часа назад
4th Normal Form 4NF , HINDI Database Normalization
4th Normal Form (4NF) , Database Normalization
Просмотров 204 часа назад
4th Normal Form (4NF) , Database Normalization BCNF ruclips.net/video/vo3H-IwC93M/видео.html 1 2 3 NF ruclips.net/video/xPzgK6sOCfg/видео.html
Boyce Codd Normal Form in HINDI #BCNF #DBMS #Normalization easiest way
Просмотров 134 часа назад
Boyce Codd Normal Form in HINDI #BCNF #DBMS #Normalization easiest way 1NF 2NF 3NF ruclips.net/video/xPzgK6sOCfg/видео.html
Boyce Codd Normal Form #BCNF #DBMS #Normalization easiest way
Просмотров 84 часа назад
Boyce Codd Normal Form #BCNF #DBMS #Normalization easiest way 1NF 2NF 3NF ruclips.net/video/xPzgK6sOCfg/видео.html
Decimal to Octal , Binary , Hexa conversion in Hindi
Просмотров 39День назад
simplest Decimal to Octal , Binary , Hexa conversion in Hindi
EASIEST Decimal to Hexa, Binary, Octal Conversion
Просмотров 17День назад
EASIEST Decimal to Hexa,Binary,Octal Conversion
EASIEST Decimal to Hexadecimal conversion with steps
Просмотров 11День назад
EASIEST Decimal to Hexadecimal conversion with steps M
BINARY TO OCTAL CONVERTER ( FRACTION )
Просмотров 29День назад
BINARY TO OCTAL CONVERTER (WITH STEPS) NUMBER CONVERSION SYSTEM COMPUTER SCIENCE
Association & Reflexive Classes in Object Oriented Programming
Просмотров 2 тыс.2 года назад
Association & Reflexive Classes in Object Oriented Programming
Partial and Tansitive dependency DBMS
Просмотров 42 тыс.4 года назад
Partial and Tansitive dependency DBMS
DBMS 1 to many,many to many,1 to 1 relationships
Просмотров 161 тыс.4 года назад
DBMS 1 to many,many to many,1 to 1 relationships
Sir bohat acha explain kia huwa hy aap NY thanks for such video
@@IrfanComputerCollege plz share it with ur class and also let me know if u want a video on any other topic
@@SaghirSchool I am a teacher . I will recommend this lecture to students.
@@SaghirSchool I will tell you if there will be need of any viseo
@@IrfanComputerCollege that you so much sir means a lot
@@IrfanComputerCollege anytime
well put
🤩tq sir
very good lecture
love hogya
Easiest normalization video ever.
🥺kitne acchese samjhaya yaar🥺udemy k courses fail h is video k aage😊
plz share with ur class
Thanks, please upload more.
sure whct topics u want me to make videos on
why Teacher 'G' teaches two subjects in 5:23? u can assign different value
Thank you very much! Best video for exam preparation with less time.
Thank you for your explanation sir! I hope I can ace my test tomorrow
thank u so much , plewase share it woth the class as well tt llll be a favour to me
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).
perfect tutorial bro found it just before exam
plz share it with ur fellows
Best explanation I’ve found on RUclips. Subbed. Thank you :)
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???
Write a query on each table
I heed one question please solve the answers question : input - a1bb2c3dd4e output - charnumcharcharnumcharnumcharcharnumchar please write the query answers
how is name dependent on both keys in 2nf
good exp
Sir please do a video on BCNF please
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 so much, this was really helpful!!
at the end u forgot to say 426 = BLA BLA BLA
clear and concise. Thank you!
Amazing video
👏
👏
HI SIR, YOU ARE SO GOOD. You explain this topic very well .
🎉best video that a DBMS student need
A big thanks thanks to u sir
Your tutorial is way clearer than some thousand dollar courses that I've seen online.
plz share it with ur fellows
Clear and concise! Thanks a lot! You should work on video flow a bit more, but the content is good
thank you so much very helpful❤❤❤❤
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
Best 🔥❤🔥
Sir Saghir the best teacher of this World...🔥❤❤❤
Thank you
What if the name column has similar name. isn't it best practice to use the primary key instead
Nice explanation
SIMPLE, PERFECT AND CLEAR
sound absolutely ecstatic mate
4:35 sorry, this is wrong. The attribute name written there is "Comment" not "ProductName". The correct query should be: WHERE Comment LIKE ..
best video
Did yourself get you just said?! ruclips.net/video/q4DOysW1XEs/видео.html
It is the best normal-form video explanation ever. I'm very appreciative.
Excellent sir.
super
thank you bhai
perfect❤
It's really helpful. Thanks