Ma'am, there is one request to you.. Please never delete these videos, come what may .... It's so raw knowledge that no book or teacher can explain such brilliantly.
A video series that literally saved my life. As a student who has had such difficulty with mathematical notations, thank you for explaining so easily. I also watch the videos with interest. Thank you for sharing your effort and knowledge with us.
watching all the way from Botswana, Africa studying computer system engineering with University of Sunderland , doing a module called advanced database technologies. Your lectures have helped me with most of the work i didnt get 1st in my lectures..
You always bring very valuable and to the point definitions, and explain the concepts very deeply. It shows how much efforts you put down to make these videos. Thank you for your hard work and may God bless you. Keep shining.
Before seeing this I was really never interested in commenting on vdeos Butt ur beautiful explanation deserves so praise for you Understood each nd every concepttt mayy God bless you wid lots of happiness for this good work.
This video discusses the need for normalization in database management systems (DBMS) to address issues like redundancy, data anomalies, and simplified queries. Key moments: 00:26 Normalization in DBMS is crucial to eliminate redundancy and improve data integrity. Redundancy leads to repetition of information, causing inefficiency and data inconsistencies. -Importance of normalization in maintaining data integrity and efficiency. Redundancy in data storage can lead to inconsistencies and inefficiencies in database operations. -Challenges of redundancy in database management. Repetition of information in tables can result in data inconsistencies and inefficiencies in managing large datasets. 05:10 Redundancy in database tables leads to various problems like insertion, deletion, and update anomalies, causing data inconsistency and errors. Normalization helps reduce redundancy and anomalies, improving data integrity and accuracy. -The importance of decomposing tables into smaller ones to reduce redundancy and improve data consistency and efficiency. -The impact of redundancy on data anomalies like insertion, deletion, and update anomalies, leading to data inconsistency and errors. -Challenges faced in database management due to redundancy, such as the inability to insert certain information without additional data, causing insertion anomalies. 10:11 Updating redundant information in a database can lead to inconsistency problems, such as update anomaly and delete anomaly, which can be solved by decomposing tables to remove redundancy and establishing relationships using foreign keys. -Update anomaly arises when redundant information is inconsistently updated, leading to data inconsistency and a poorly designed database. -Delete anomaly occurs when deleting a record unintentionally removes related information, highlighting the importance of proper database design. -Decomposing tables into separate entities and establishing relationships using foreign keys can help eliminate redundancy and ensure data integrity in a relational database. 15:15 Normalization is the process of eliminating anomalies in a database by dividing tables to prevent redundant data, ensuring efficient queries and data integrity. -Importance of Foreign Keys. Foreign keys establish relationships between tables, ensuring data integrity and preventing insertion anomalies. -Solving Anomalies. Normalization resolves insertion, update, and delete anomalies by structuring data into separate tables, maintaining data consistency. -Normalized vs. Denormalized Data. Normalized data is crucial for OLTP systems to handle frequent transactions, while denormalized data is preferred for analytical processing to enhance performance. 20:19 Normalization in database management helps minimize null values, simplify database structure, and improve query performance by dividing data into separate tables for better understanding and efficiency. -Importance of minimizing null values in database management for efficient data storage and retrieval. -Significance of simplifying database structure through normalization for better data organization and query optimization. -Challenges and benefits of decomposing tables correctly to avoid data loss and ensure effective database design.
Ma'am. Thank you very much for this lecture series of normlization. I was always afraid of the normalization as i had trouble understanding it. But after i watched your lecture videos, i understood it and I got distinction in database assignment and passed the database exam with flying colors (97/100)! Thank you so much.
Hi mam Iam so much Happy today because of your video and your explanation way I learned alot of things and Finally I got a job in Software Company As a trainer Thank you sooo much mam
Thanks mam,,,because avi youtube me vhi jo vi aducation video dal ta gai ooo bad mai important kuch jab ata hai tab us logo ne payment system kar lete,,,but you mam also teach 1 year many subject and solve our many problem without any payment its very help full foe middle class family student agin and agin i told thank you so much dear mam❤❤❤and love you also😁
I never commented to any video or subscribe yet but I love your teaching style , it is Very understandable yet you teach in English but completely understandable I always dream to have a such teacher ,mam please teach computer architecture and network also as I'm preparing for hssc tgt computer science if u started classes for that it would be pleasure
I already like you sister Jenny, you're the best teacher i ever had in You-tube. I understand you well and please i wanna follow you for i have things i need help to become DBA.
you are a genius Mam, thank you for clearly specifying each concept as per an example of real-world entities, My everyday Mentor, l really appreciates your love of sharing excellent examples for free
Thank u Jenny mam. Ur videos are simply superb and very comfortable to get the knowledge about the particular concepts. By the way u r explaining each and every concept with a versatile example, which really helps us to deal with real time entities. Good job mam...and :clap :clap :clap to ur efforts. I support u.
Mam thanks a lot for these kind of videos , basically i'm from another field , and i experienced a lot of problemes regarding this normalisation topic in DBMS , now i'm fully hands on this Normalization in my practical work....... Thanks a Lot...............................
Mam, ❣️well teaching..💟💟verry good...❣️❣️❣️😍😍😍😍 I got easy the concept of normalization.. 😊😊please upload more videos in DBMS..🙏🙏.👍👍All the best....keep the simplest teaching method....❣️❣️❣️❣️❣️
You are really something beautiful mam ❤️ i mean as a human being we always have on mind what we can take from this world but ur personality always that what i can give to this beautiful world 💓 and thats what make you the world's most beautiful person, rather i say Jenny The Miss WORLD👸 .
you are doing great job jenny. I appreciate your effort for the thought of those less privilege people. God bless you. never disappoint yourself from the acts of stupid people. keep it up
i have dought at update anomly at 11:10 ,if you update record according to dept name cse than entire table which contains cse records will be updated right......than your telling that if i updated 2 records and forgot to update 1 record .....i didnt got this.....
Hi! Thank you for this very educational video! You've explained it very well and easy to understand. We use your video in our class. Thank you! You are also so pretty
Nice presentation - see this is what we need, the smartest student in the class ( for the past several decades at least) are the girls. I recently took a grad astrophysics class , there were some incredibly smart young women in the class, their presentations were so fast incredibly well done and deep that it was almost impossible to keep up, as for exams they were done in less than half the allotted time, and yes many if them perfect physical specimens. But its not just academics, young women have emerged as outstanding talented athletes , watch some collegiate womens basketball or softball snd i think you will be amazed if you open your eyes put aside your bigotries and be honest with yourselves.
I've reached a point with my databases class where I sign the attendance, then watch these videos instead :P
Very true 😂😂😂
Same, I'm in DMIT 1508 at nait and it's dull sometimes and only 1 instructor that teaches it.
Same here...lol and I am from Srilanka 😅
@@messifan7499 yo me too
Ma'am, there is one request to you..
Please never delete these videos, come what may ....
It's so raw knowledge that no book or teacher can explain such brilliantly.
dont show the anxiety broo.
notes:
1. prevent data redundancy
2. prevent insertion, deletion and updation anomalies
A video series that literally saved my life. As a student who has had such difficulty with mathematical notations, thank you for explaining so easily. I also watch the videos with interest. Thank you for sharing your effort and knowledge with us.
Professor Jenny! You are my goddess in DBMS!!! Your lectures are brilliant. Love and Support from Australia!!!
watching all the way from Botswana, Africa studying computer system engineering with University of Sunderland , doing a module called advanced database technologies. Your lectures have helped me with most of the work i didnt get 1st in my lectures..
You always bring very valuable and to the point definitions, and explain the concepts very deeply. It shows how much efforts you put down to make these videos. Thank you for your hard work and may God bless you. Keep shining.
Greatest of all times lectures ,,,all what I need for my own project 🔥
,😱😱
Allah bless you.
Before seeing this I was really never interested in commenting on vdeos
Butt ur beautiful explanation deserves so praise for you
Understood each nd every concepttt mayy God bless you wid lots of happiness for this good work.
This video discusses the need for normalization in database management systems (DBMS) to address issues like redundancy, data anomalies, and simplified queries.
Key moments:
00:26 Normalization in DBMS is crucial to eliminate redundancy and improve data integrity. Redundancy leads to repetition of information, causing inefficiency and data inconsistencies.
-Importance of normalization in maintaining data integrity and efficiency. Redundancy in data storage can lead to inconsistencies and inefficiencies in database operations.
-Challenges of redundancy in database management. Repetition of information in tables can result in data inconsistencies and inefficiencies in managing large datasets.
05:10 Redundancy in database tables leads to various problems like insertion, deletion, and update anomalies, causing data inconsistency and errors. Normalization helps reduce redundancy and anomalies, improving data integrity and accuracy.
-The importance of decomposing tables into smaller ones to reduce redundancy and improve data consistency and efficiency.
-The impact of redundancy on data anomalies like insertion, deletion, and update anomalies, leading to data inconsistency and errors.
-Challenges faced in database management due to redundancy, such as the inability to insert certain information without additional data, causing insertion anomalies.
10:11 Updating redundant information in a database can lead to inconsistency problems, such as update anomaly and delete anomaly, which can be solved by decomposing tables to remove redundancy and establishing relationships using foreign keys.
-Update anomaly arises when redundant information is inconsistently updated, leading to data inconsistency and a poorly designed database.
-Delete anomaly occurs when deleting a record unintentionally removes related information, highlighting the importance of proper database design.
-Decomposing tables into separate entities and establishing relationships using foreign keys can help eliminate redundancy and ensure data integrity in a relational database.
15:15 Normalization is the process of eliminating anomalies in a database by dividing tables to prevent redundant data, ensuring efficient queries and data integrity.
-Importance of Foreign Keys. Foreign keys establish relationships between tables, ensuring data integrity and preventing insertion anomalies.
-Solving Anomalies. Normalization resolves insertion, update, and delete anomalies by structuring data into separate tables, maintaining data consistency.
-Normalized vs. Denormalized Data. Normalized data is crucial for OLTP systems to handle frequent transactions, while denormalized data is preferred for analytical processing to enhance performance.
20:19 Normalization in database management helps minimize null values, simplify database structure, and improve query performance by dividing data into separate tables for better understanding and efficiency.
-Importance of minimizing null values in database management for efficient data storage and retrieval.
-Significance of simplifying database structure through normalization for better data organization and query optimization.
-Challenges and benefits of decomposing tables correctly to avoid data loss and ensure effective database design.
The world will become easy to live
If we have a many teachers and persons like you,
Thank you , may god bless you
Ma'am. Thank you very much for this lecture series of normlization. I was always afraid of the normalization as i had trouble understanding it. But after i watched your lecture videos, i understood it and I got distinction in database assignment and passed the database exam with flying colors (97/100)! Thank you so much.
Even after 4 years, we still watch you jenny
Its my final semester project i will copy all of your words for presentation😂😂😂you teach in a very good manner keep it up❤❤❤
This year me
Did it go well?
@@entertainment20244-k yes.... 8 mins presentation 😁
Please make more videos on DBMS,we really need them!
Hi mam
Iam so much Happy today because of your video and your explanation way I learned alot of things and Finally I got a job in Software Company As a trainer
Thank you sooo much mam
Your lectures have really helped me to learn DBMS concepts. Thanks for teaching in such a simple manner. ☺
whats ap nambar de do
Plato: Ignorance is the root cause of all the problems.
Jenny: Redundancy is the root cause of all the problems.
thank you ma'am me last time par dekhi hai exam chal rahe hai mere ye videos pure topic clear ho gye mere thanks a lot..
Your tutorials have saved me all time in exams thanks lots of love
You’re far better than my teacher. Thank you so much
Your lecture help me at the time of exam thank you for all
Who think this is the best video on normalization .....
Jenny ma'am is the best ...
Hit like 👇👇👇
Jenny you are doing great job....you deserve more subscriber.......No one can teach ds,algo and dbms better than you in the you tube channel.
Cảm ơn bạn!
Apke jaisa koi nhi mam ❤️
Jenny, for first time i understood what is the purpose of normalization. Big thanks.
Thanks Jenny! Helping a friend out with his DB exam and found this video very useful.
"Right" is the favourite word of jenny
Madam your teaching way is awesome so love it ❤
YOU ARE MY GODDESS!!! your explain is absolutely excellent!!!
Thanks mam,,,because avi youtube me vhi jo vi aducation video dal ta gai ooo bad mai important kuch jab ata hai tab us logo ne payment system kar lete,,,but you mam also teach 1 year many subject and solve our many problem without any payment its very help full foe middle class family student agin and agin i told thank you so much dear mam❤❤❤and love you also😁
I never commented to any video or subscribe yet but I love your teaching style , it is Very understandable yet you teach in English but completely understandable I always dream to have a such teacher ,mam please teach computer architecture and network also as I'm preparing for hssc tgt computer science if u started classes for that it would be pleasure
Thanks mam Allah ape ko buhat sari izat or tension free zindagi day amen
Mam you explained it in very easy way. And I understood it easily. Thank you very much.
This video series is a goldmine for all data developers 🔥🔥 Thank you so much for postng such valuable info for free!
Thank you so much ma'am . These lectures are very useful specially in this time of semester end examinations
Half of my degree's credit goes to you Jenny ❤️😁
right.....the video is lit!!!!.....just the way she says "RIGHT" and FINE
Your explanations are so succinct and concise...thank you so much
Internet is a better place because of people like you
you saved my life again again and again
Thanks ma''am to explain this so nicely.
I already like you sister Jenny, you're the best teacher i ever had in You-tube. I understand you well and please i wanna follow you for i have things i need help to become DBA.
Thank you very much for taking your time and giving the valuable knowledge to us free of cost may u always teach in this manner
you are a genius Mam, thank you for clearly specifying each concept as per an example of real-world entities, My everyday Mentor, l really appreciates your love of sharing excellent examples for free
thank you mam, for making this lecture i'm watching this lecture 1 day before exam:)
Good way of teaching 👍🏻
Very well explained mam thanks for your priceless efforts,INDIAN😊😊😊
Thank you very much from Moroccan follower
Thank u Jenny mam. Ur videos are simply superb and very comfortable to get the knowledge about the particular concepts. By the way u r explaining each and every concept with a versatile example, which really helps us to deal with real time entities. Good job mam...and :clap :clap :clap to ur efforts. I support u.
Thank you so much for this amazing explanation:)
Thank you. You have no idea how helpful this is for me
best teacher ever
Nice explanation.Clear Explanation.
Appreciate your hard work. And explanation is too much adorable.
Simplified explanation always gets thumbs up. Thank you.
Thank You Mam for such an amazing lecturr 🙏🙏
i am from BCA filed and it's helps me in my examination of DMA
thanks for teaching
Mam thanks a lot for these kind of videos , basically i'm from another field , and i experienced a lot of problemes regarding this normalisation topic in DBMS , now i'm fully hands on this Normalization in my practical work.......
Thanks a Lot...............................
Simply love you mam you saved me ❤️
20:00 - benefits of normalisation
We love you Jenny from ethiopia🥰🥰🥰
Superb !! Great way of teaching.. Respect Madam.
Wow, thank you again. Excellent video and class.
Hey happy teacher's day!
everytime i see her videos and only one line comes out "see, Thats how you teach" HATSOFF!!!!
i'm spending my all day in this playlist.
this is soo helpful. thank you very much Jenny!
Mam, ❣️well teaching..💟💟verry good...❣️❣️❣️😍😍😍😍 I got easy the concept of normalization.. 😊😊please upload more videos in DBMS..🙏🙏.👍👍All the best....keep the simplest teaching method....❣️❣️❣️❣️❣️
I LIKE YOUR EXPLANATION
YOU ARE BEST TEACHER
CONTNIUE IT
my goodness how impressive is your explanation.. may god bless you with more and more in everything.
Very well explained Jenny !!
🤗🤗🤗🙌🙌🙌
You are my Inspiration ma'am 😀
Thank u mam. Easily understandable and neat explanation 👌
You are really something beautiful mam ❤️ i mean as a human being we always have on mind what we can take from this world but ur personality always that what i can give to this beautiful world 💓 and thats what make you the world's most beautiful person, rather i say Jenny The Miss WORLD👸 .
you are doing great job jenny. I appreciate your effort for the thought of those less privilege people. God bless you.
never disappoint yourself from the acts of stupid people. keep it up
tons of love (thanks) from odisha( Sambalpur)
Good explanation, I learned about benefits of normalisation in some books, got to know about 3 anomalies from this vid, ty
Thankyou mam 😃,it was very simple explanation of Normalization, I couldn't understand this through my course book.
Jenny, you are a great teacher, I have struggled so much understanding this but now its very clear. Thank you
Your explanation is very nice Mam. Thanks to teach us.
Great presentation.. Thank you ma'am.
i have dought at update anomly at 11:10 ,if you update record according to dept name cse than entire table which contains cse records will be updated right......than your telling that if i updated 2 records and forgot to update 1 record .....i didnt got this.....
Hi! Thank you for this very educational video! You've explained it very well and easy to understand. We use your video in our class. Thank you! You are also so pretty
Very helpful video thank you mam
ruclips.net/channel/UC5UCDqBotPtxQgfum4iGM2A
Clean and Clear explanation..
Thankyou Normalisation Concept Clear
Kunal Singh 19 minutes upload kiye hue h or video h 23 minutes ki or tumne 16 minutes m hi normalization ka concept clear kr liya ....
@@lavitdubey561 🤣🤣🤣
SHASHIKANT GUPTA ✌✌✌
@@lavitdubey561 Bhai Forward Karke Dekha waise Maine padh rha tha aur example Mai clear ho gya waise aap apna concept clear aur comment tumhare liye nhi tha
Kunal Singh Achaa ho gaya concept clear ... To thik hai
A friend in need is a friend in deed
Thank friend (BFF)
FROM AP ❤️
Very well explanation👌👌👌
Dear lavely maam I am from Bangladesh, Your One of the best teacher in my life, come to visite Bangladesh,,,,,love u tooo,,,maam
Great explanation Mam 🙏🏻
You're great mam.thank you so much ❤️
Hats 🎩🎩🎩🎩🎩🎩🎩 off to you ma'am.
It is like the way you explain things just resonates with my brain in a way that is hard to find elsewhere. Thanks for sharing!
You are absolutely amazing!!
Is it a continued echo.. or you are saying "Right!" After every statement ?
Thanks for good explanation mam
I like you and your teaching style .
Nice presentation - see this is what we need, the smartest student in the class ( for the past several decades at least) are the girls. I recently took a grad astrophysics class , there were some incredibly smart young women in the class, their presentations were so fast incredibly well done and deep that it was almost impossible to keep up, as for exams they were done in less than half the allotted time, and yes many if them perfect physical specimens. But its not just academics, young women have emerged as outstanding talented athletes , watch some collegiate womens basketball or softball snd i think you will be amazed if you open your eyes put aside your bigotries and be honest with yourselves.