4.1 Insertion Deletion and Updation Anomalies, Data Redundancy Inconsistency in DBMS
Вставка
- Опубліковано 19 жов 2024
- 📝 Please message us on WhatsApp: wa.me/91800012...
💻 KnowledgeGate Website: www.knowledgeg...
📲 KnowledgeGate Android App: tiny.cc/KG_Offi...
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgeg...
🟠 GATE Guidance-2026: www.knowledgeg...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/91859512...
📞Call on: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 Email: contact@knowledgegate.in
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_D...
▶️ Compiler Design: tiny.cc/kg_yt_C...
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_D...
▶️ Algorithms: tiny.cc/kg_yt_A...
▶️ Set, Relation, Function: tiny.cc/kg_yt_D...
▶️ Graph Theory: tiny.cc/kg_yt_g...
▶️ Group Theory: tiny.cc/kg_yt_g...
▶️ Proposition: tiny.cc/kg_yt_p...
#knowledgegate #GATE #sanchitjain
*********************************************************
For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.html
This is the most cheerful youtube educational channel. Sanchit sir himself is such an enthusiastic teacher. His passion for teaching is visible clearly.
These types of teacher are one in a million
exactly nigga
Concept is clear now...so easy and understandable....It's only bcoz of you sir. .thnxx a lot🙇
Thanks is not enough for this well explanation of data redundancy. You are the greatest teacher I ever find in my life.
It amazes me how many english speakers in the comments are able to understand him seamlessly.
I think I'd feel he was as helpful to me as he is to everyone else if I could actually understand him.
Hello sir , I am from Nepal .
During my class I was unable to concentrate on these topic and after watching this i am able to know about all this ..Thank you sir, thank you very much 😊😊
God bless uh sir , u r truly amazing teacher ,all my good wishes are with u keep doing this work .hearly thanks for ur superb videos
6:34 complete view of whiteboard
bhai bhai..
❤❤
played at 1.5x speed and exam preparation done in 2 days ... ezzpzz
Bitch please 4 hours here
pros watch it at 2x
@Ocean Of Fun -KO aap gyaan kahi aur baate
@@beniboi7953 add me then on pro gang 😅
god
Thank You Sir.This is the best you tube channel and i am fan of ur teaching.You have clarified many doubts that i have stuck in Databases
i wish my college teacher to teach as u do......u r the best............
sir..
I am a civil engineer .I learn every concept in finest way onley due to u.Thanks a lot of sir.
Out of context , but a thought which I want to say,
1. Why a concept has to be learned.
2. Right in the start, a brief overview of what has to be done and interdependencies b/w them.
I think these two things should implemented in our education system.
It will make things interesting , which otherwise is a burden.
Whole feels like rattafication.
The concept "processing speed" over "storage" .
This is my personal favourite reason to learn from sanchit sir and I am thankful to him for that.
खूपच सुंदर Explanation
Keep watching, visit www.knowledgegate.in for more courses and content !!
Thank u so much sir...tomorrow is my interview this is cleared my topic from top to bottom and head to toe.❤
So did you got the job
Boss ap ny Kia smjhaya hai jo cheez mere sir mujhy 2 weeks me nhi smjha paye aap me 15 mintues me smjha dia
You have skills sir 😊
Thanks a lot. Sir please make a video series on computer networking.
Your video is really very helpful for us because of your content delivery style and teaching we are getting each and every topic of such type of theoretical paper...Thank you and ton of thank you sir...
Very nice and easy way to explain .good job done....
Thank You sir for this amazing explanation...
You are most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
wow seriously sir what a lecture ...... thnk u so much i understand 100% .... umer From Pakistan
PAKISTAN MURDABADH , HINDUSTAN ZINDABAD.
very good equational channel on youtube............thanks sir
Hello sir .. ur way of teaching is mind blowing .. u r genius... Sir plz make a introductory lecture in dbms like physical conceptual view ..
Sir,
You are very passionate about teaching. I have attended made easy classes and ravindrababu ravula classes for gate. But your explanation way of the topic is best.
Hahahaha ,,,, very sad even after made easy classes of Reddy Sir u were nt able to understand.. How dull u were...
@@pushpamassi3142 hey Pushpa Massi ji,
I haven't refereed reddy sir here.
at my time DBMS was taught by other teacher not by reddy sir.
and It is my point of view about this lecture, you have no need to react on this, GO AND GET SOME LIFE.
Never seen teacher like Sanchit sir ❤
brother bht acha explain kia ha ap ny ....bus ak kam ho sky tu kr dain k apni videos ko upload krty hoya start ka kuch url same kr dain us sy apki baki videos ko dekhna zra asaan ho jya ga .thanks
Keep this up
Good job
This video cleared my all doubts regarding anomalies. Thank you sir
bro you are the best , i salute you
So easy language and understable language,,,,,,Perfect
First I like your video and then I start watching your video.
Thank you so much sir
superb explanation sir, i understand easily.
Thank you Prabhat.. Keep learning and supporting !!
Nice explanation
Thank you dear @aastha❤ keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing videos & contents👍
very well explained sir.keep going.hope to see more such videos.
You are THE best. Role model.
you are GOD. No doubt. 🙏
well explained recommended one
Thanks 😀Visit tiny.cc/yt_kgwebsite for more courses and content !!
add a video on converting ER diagram to table...then it will be a complete playlist ♥
Dear Imraan, for complete course on DBMS, please check out the link given below:
www.knowledgegate.in/learn/DBMSbysanchitsir
best teacher ever: sanchit sir
Thanks a lot Tanya ❤️❤️ :) Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
woowwww... what a great i found on youtube,,,,Thanks to me an of-course Knowledge Gate...:)
sir your method is number one anyone can undersatnd easily
I like your way to teach sir pehle problem samjho then solution
Sahi video!
This is the video we need but not the video we deserve.
Speechless
Thanks a lot dear sir
awesome explanation sir
Thanks a lot dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
Thanks a lot Sir JI!! Please Keep up This Godly Work
Thanku sir, i am your fan, i like your teaching way that separate you from others.
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
Wonderfully explained sir!
Thank you sir 🙏🙏🙏
Most welcome dear! Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
But sir we don't have to update data by going on each row ...we simply need to write update command (i.e. update hod_name= "abc" where hod_name="xyz"; ) and the data will automatically update.........then how updation anomaly is causing problem?
Awesome.....way of teaching
Sir, please please can you make video lectures on ER and EER model?
Thank u sir for this awesome content
Most welcome dear Akhand, keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
Great teaching
Thanks a lot dear❤ Keep learning & supporting! Stay connected for more amazing contents & videos 👍
Sir ...u r a genius 🙏🙏🙏thankyou for the playlist 🙏🙏
Sir u r doing really good job.plz keep it up.
thank you so much sir.please make video on System analysis and design .
I am glad to subscribe this channel👍
Tnk u sir.... you are a good teacher..god bless you
Hello sir You are great !!!
Please sir recommend me any good book for DBMS and Operating System
with author name please
U r a great teacher sir
Thank you sir you made all concept clear....
Sir please make a series on image processing
There are no videos on net by this topic
Thanks a ton!!!
You're welcome! Keep following & stay connected for more amazing contents👍😊
You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
Thanks sir g
U are amazing sir urs videos are understandable thanku sir
Thank you very much sir .
You are a good teacher
Great
Thank you! Keep supporting & stay connected for more amazing contents👍😊
You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
Very helpful video thanks sir
Great job sir
I Am not able to understand Update Anomaly.Because if HOD_Name is changing of CS branch then i can write query to change HOD_Name of Branch_Name like "Update Table_Name set HOD_Name = 'ABC' Where Branch_Name = 'CS' "
great elaboration.
Nice explanation ❤
Thank you 🙂Keep learning & stay connected for more amazing contents👍😊
You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
sir plz complete all the remaining playlists for GATE ♥
Dear Imraan, for complete course on Computer Science, please check out the link given below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
Love u sir. Thank you so much for help.
1:43 start
Hello sir,
I can't understand how redundancy create insertion and deletion anomalies?
Please clear my doubt...
Thank you so much
If the data is stored redundantly in the same table, and the person misses any of them, then there will be multiple titles associated with that candidate key
The disadvantage of slowness that you mentioned in the video doesnt looks to be correct. Because Denormalization is done for faster retreival.
Sir you are superb
@sanchit sir I have a doubt in instertion deletion anomalies. In insertion anomaly we know our table has branch field ,branch code field, and hod field if we even don't have a student in any branch we can easily add the new admitted student in table regardless of whether any student is already present in the database Or not. Then why you are saying that we cannot add a new student in the db table when there is no student of any branch already enrolled over there??
Any help explanation is open please clear my doubt :)
Excellent
Thank u sir
Transaction ka checkpoint concept !
thanks
Sir you are legend
Sir g tusi shazade o
This is a good channel
Thank you so much for your recommendation my friend.
Thanx a lot sir....
Good Job
Sir please upload in english...😢😢👍👍👍👌👌
You are amazing sir love from Pakistan😍😍😍
Khud ke Pakistani teacher se pdh le naa lodu
PAKISTAN MURDABAD , HINDUSTAN ZINDABADH
Thank you sir ♥️
wow sir too good
Very nice
gr8 video sir
Why can't we write the following query to insert a record in student_info table for civil branch?
Insert into student_info values(7, 'abc',18,107,'civil', 'jsllwl');
well we can write ,but the point is that suppose we only want to add branch to our college .in that case we need a student to mention it other wise our primary key would have a null value i.e unacceptable
What is the difference between redundancy and duplicacy in dbms??
duplicacy may be wanted or unwanted but redundancy is always unwanted
Epic!
Thanks dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊