Insertion anomalies: The user cannot insert data into column In dbms bcs PK is not inserted, while user only wants to insert data not including PK. Therefore, user needs to wait for PK to be inserted before data can be inserted. Ex: only insert course related info, no student info, because the student info and course info are in the same table, there exist NULL values. Changing table to normalized form solves these problems. Update anomalies: Update column data的时候另一个column with same data to be updated is not updated, 有不同的data，不能确定data的准确性 Delete anomalies: Delete 删掉一个column data, same column other data that isnt meant to be deleted will also be deleted.
Insertion anomalies:
The user cannot insert data into column In dbms bcs PK is not inserted, while user only wants to insert data not including PK. Therefore, user needs to wait for PK to be inserted before data can be inserted.
Ex: only insert course related info, no student info, because the student info and course info are in the same table, there exist NULL values. Changing table to normalized form solves these problems.
Update anomalies:
Update column data的时候另一个column with same data to be updated is not updated, 有不同的data，不能确定data的准确性
Delete anomalies:
Delete 删掉一个column data, same column other data that isnt meant to be deleted will also be deleted.
Nice clarification. Thanks.
Nice explanation ma'am ! It our pleasure that you r teaching us Software Engineering also
--Love from IEM'k
It's my pleasure, glad to hear that!
Thankyou madam amazing explanation.....Now my doubt is clear about this topic.
Glad it was helpful... Please do share with others, who might also find the video useful.
Great explanation short and precise thanyou mam
Clearly explained the concept. ❤
Glad it was helpful. Please share with others
Great. very clear explanation.💖
Very educational, but I feel like I got motion sickness after watching this!
Thank you so much for the detailed explanation!!! Really helped
Thank you! Please do share, if you know someone who will be benefited.
Very very good explanation! Thnx
Understood well thankyou ma'am 🤩🤩
You are welcome! Please do share, if you know someone who will be benefited.
thanx a lot mam got the idea just because of you....thanks again....❤❤❤
Great 👍 Happy to help, please share with others who can also find the video useful
Thank you ma'am... This helped me a lot!
Glad it was helpful!
Thank you ma'am! It helps me a lot.
Very good explanation!! Thank you.
Glad, you liked the explanation. Please do share with students who can also be benefited.
🔥🔥🔥🔥🔥🔥
Great explanation, Thank you so much
You are welcome! Please do share with others who can also find it helpful
khub bhalo mam, thank you so much
so beautifully rendered. thank u
Thank you. Please do share with others.
Really Nice video
Glad you found it helpful, please share with others!
Really good video
Glad to hear it was helpful, please share with others!
very good explanantion ma'am...but it would be better had the flickering underlines were simple underlines
Thank you for the feedback, keep watching and share with others.
Thank you mam your explanation is very good ❤️
Thank you! Please do share, if you know someone who will be benefited.
👌 Very helpful
Nice explanation madam...!!
Osm editing
Glad you liked it!
Nicely presented.. Thank you.
You are welcome, please do share with others
Great maam
how is your video quality so good
Glad to hear it was helpful, please share with others!
thank you .but most of the time dose not put the last result.
Is no one going to mention that we don't know what to insert? Into null spaces? Like do you make something up?
Sorry, didn't get your question. Can you please rephrase it?
Thank you madam..
Welcome 😊
Thank you madam 😊
you are Welcome. Please do share with others
Thank you 🥰
Thank you so much
👏👏
The W pronunciation in English is not like V it’s more like U
Thanks mam...
You're welcome. Keep watching
@@aninditadas5940 mam plz make a video on b+ tree for gate question...
On repeat
best
Thank you. Please do share with others
Thanks a lot ❤
شكرا
thank u mam
Happy learning!
It's to lengthy
Worst classs