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.
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.
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..
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.
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.
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
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...............................
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.
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.
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😁
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
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 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
please make videos on writing queries,tables,pl/sql queries, Clauses like group by clause, where clause,etc., they are just many if you open any dbms book 😅
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
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.
Jenny, Normalization is key for OLTP databases. I'm oracle dba managing huge(petaybyte) databases Performance is screwed up due to lot of redundancy in tables. Performance caused by fragmentation ! For rdbms pks and fks are v important !
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
You told that these anomalies occur due to redudancy, but how insertion anomaly is related to redudancy?it occurs due to the poor design of the table right?
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.
Hai Jayanthi mam, in updating of the tuple in the relation we can just use {update table_name set building=c1 and number=130 where dept="cse"}. Here any kind of update anomaly will not taken place. Then how can we say that anomaly occurs here. I think it's not the correct example of update anomaly.
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.
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.
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..
Professor Jenny! You are my goddess in DBMS!!! Your lectures are brilliant. Love and Support from Australia!!!
notes:
1. prevent data redundancy
2. prevent insertion, deletion and updation anomalies
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.
Greatest of all times lectures ,,,all what I need for my own project 🔥
,😱😱
Allah bless you.
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?
@@Mysteriousking24 yes.... 8 mins presentation 😁
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
The world will become easy to live
If we have a many teachers and persons like you,
Thank you , may god bless you
Your lectures have really helped me to learn DBMS concepts. Thanks for teaching in such a simple manner. ☺
whats ap nambar de do
Please make more videos on DBMS,we really need them!
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.
Thanks Jenny! Helping a friend out with his DB exam and found this video very useful.
Your lecture help me at the time of exam thank you for all
Plato: Ignorance is the root cause of all the problems.
Jenny: Redundancy is the root cause of all the problems.
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!
Who think this is the best video on normalization .....
Jenny ma'am is the best ...
Hit like 👇👇👇
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
Jenny, you are a great teacher, I have struggled so much understanding this but now its very clear. Thank you
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...............................
my goodness how impressive is your explanation.. may god bless you with more and more in everything.
Your tutorials have saved me all time in exams thanks lots of love
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.
Thank you so much ma'am . These lectures are very useful specially in this time of semester end examinations
Jenny, for first time i understood what is the purpose of normalization. Big thanks.
Even after 4 years, we still watch you jenny
You’re far better than my teacher. Thank you so much
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
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.
Is it a continued echo.. or you are saying "Right!" After every statement ?
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.
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..
This video series is a goldmine for all data developers 🔥🔥 Thank you so much for postng such valuable info for free!
Mam you explained it in very easy way. And I understood it easily. Thank you very much.
I'm just addicted to your way of teaching mam... Thank you so much..
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😁
Madam your teaching way is awesome so love it ❤
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 explanations are so succinct and concise...thank you so much
you saved my life again again and again
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 MY GODDESS!!! your explain is absolutely excellent!!!
Nice explanation.Clear Explanation.
Simplified explanation always gets thumbs up. Thank you.
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
Thanks mam Allah ape ko buhat sari izat or tension free zindagi day amen
please make videos on writing queries,tables,pl/sql queries, Clauses like group by clause, where clause,etc., they are just many if you open any dbms book 😅
Thank you so much for this amazing explanation:)
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
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.
best teacher ever
Apke jaisa koi nhi mam ❤️
Thank you. You have no idea how helpful this is for me
this is soo helpful. thank you very much Jenny!
Good explanation, I learned about benefits of normalisation in some books, got to know about 3 anomalies from this vid, ty
Jenny,
Normalization is key for OLTP databases. I'm oracle dba managing huge(petaybyte) databases
Performance is screwed up due to lot of redundancy in tables. Performance caused by fragmentation !
For rdbms pks and fks are v important !
Appreciate your hard work. And explanation is too much adorable.
I LIKE YOUR EXPLANATION
YOU ARE BEST TEACHER
CONTNIUE IT
Half of my degree's credit goes to you Jenny ❤️😁
Thank u mam. Easily understandable and neat explanation 👌
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
Thankyou mam 😃,it was very simple explanation of Normalization, I couldn't understand this through my course book.
thank you mam, for making this lecture i'm watching this lecture 1 day before exam:)
20:00 - benefits of normalisation
Superb !! Great way of teaching.. Respect Madam.
Wow, thank you again. Excellent video and class.
Thanks for watching guy's
Thank u 2
😂😂😂
Rajit ☺
"Right" is the favourite word of jenny
Very well explained mam thanks for your priceless efforts,INDIAN😊😊😊
i am from BCA filed and it's helps me in my examination of DMA
thanks for teaching
Your explanation is very nice Mam. Thanks to teach us.
Hey happy teacher's day!
i'm spending my all day in this playlist.
mam, can you please teach about data warehouse concepts, schemas. will be really helpful.
right.....the video is lit!!!!.....just the way she says "RIGHT" and FINE
I really love your lectures.
Good way of teaching 👍🏻
You told that these anomalies occur due to redudancy, but how insertion anomaly is related to redudancy?it occurs due to the poor design of the table right?
very clearly understood ,good one Jenny & Tqu
Very well explained Jenny !!
🤗🤗🤗🙌🙌🙌
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.
Thank You Mam for such an amazing lecturr 🙏🙏
You have degraded ECE dept as in the data base there is only one student, and you are asking him to leave the college.
Internet is a better place because of people like you
Hai Jayanthi mam, in updating of the tuple in the relation we can just use
{update table_name set building=c1 and number=130 where dept="cse"}.
Here any kind of update anomaly will not taken place. Then how can we say that anomaly occurs here. I think it's not the correct example of update anomaly.
Great explanation Mam 🙏🏻
Clean and Clear explanation..
Jenny you are great, nice presentation
Thank you very much from Moroccan follower
Simply love you mam you saved me ❤️
Ma'am are these lectures according to the syllabus of btech. Or the syllabus of gate and all are some what different
Great presentation.. Thank you ma'am.
tons of love (thanks) from odisha( Sambalpur)
Thank you mam.. Which will help in UGC topic
Thanks for the videos; appreciate it.
well explained thanks. your videos are helpful
Plz upload lectures on transaction processing and management also mam.
You are absolutely amazing!!