DBMS | L-11 | Lossles & Lossy, Dependency Preserving Decomposition | Vishvadeep Gothi
Vložit
- čas přidán 29. 05. 2022
- GATE Ultracombat, enrolment link: unacademy.com/combat/gate-ese...
In this session, educator Vishvadeep Gothi will be discussing Lossles & Lossy, Dependency Preserving Decomposition from DBMS
Use code "VDEEP10". Price hike coming soon! 📈
Click now: unacademy.onelink.me/RICs/4sq...
Call Vishvadeep Gothi's team on 8585858585 and take your GATE & ESE Preparations to the next level.
Special class: unacademy.com/class/cache-pyq...
Best Classes of all time by Top Educators (CS/IT)
bit.ly/3uGIc2w
We got you covered for GATE 2023 Preparation, upcoming CS-IT batches:
All Star Batch for GATE 2024 (CS & IT) - Batch A:unacademy.com/batch/all-star-...
All Star Batch for GATE 2023 (CS & IT) - Batch C: unacademy.com/batch/all-star-...
Community - unacademy.onelink.me/RICs/1p4...
About the educator: Studied at Indian Institute of Science Bangalore. GATE-AIR 19, 119, 440, 682
Follow Vishvadeep Gothi on Unacademy: unacademy.onelink.me/RICs/zgi...
Join our Exclusive Telegram Channel for GATE & ESE: t.me/UnacademyGATECS
Playlist Link: • Vishvadeep Gothi | GATE
You can enroll to Unacademy Subscription and get the following benefits:
1. Learn from your favorite teacher
2. Dedicated DOUBT sessions
3. One Subscription, Unlimited Access to Live Online Classes and Videos
4. Real-time interaction with best-in-class teachers
5. You can ask doubts in live online classes
6. Limited students in each Class
7. Download the videos & watch them offline
Download the Unacademy Learning App here:
Android: unacademy.onelink.me/081J/40a
iOS: unacademy.onelink.me/081J/a61
If you don’t wish to miss any updates and or latest videos about GATE & ESE Exams Preparation, subscribe to the channel now. Students who have already subscribed, stay tuned as we will get more strategy and preparations videos and FREE LIVE CLASSES just for you. Feel free to spread the word - share the videos with your friends and classmates.
#DataStructures #Gate #VishvadeepGothi
GATE Unlock25 Offer
Get flat 25% & FREE Extension
Join the new Foundation batches for GATE, ESE*, & PSUs 2024
➤ Subscribe today: unacademy.com/goal/gate-cs-it/NVLIA/subscribe?referral_code=VDEEP10
Starts at 7:24
thank you sir for making dbms so easy I was so afraid of this subject as i got a backlog in it and found it difficult to understand but you made it so easy in the backlog clearing semester i got full score in dbms never thought i could do that😁
Thanks Sir
thank you sir for this kind of the video in the free for the lifetime learning
Starts at 00:06:20
Please make a playlist for data structure 2023 and DBMS
In the example you gave in the last video, where R(A, B, C, D, E, X, Y) and F+ = { AB -> C, AC -> B, AD -> E, B -> D, BC -> A, E -> X} if you carry out 2NF form decomposition, you get lossy decomposition at 2NF but in this video you said that 2NF decompositon only happens in BCNF. I am confused.
r1(a,b,c,e,x,y) and r2(b,d) therefore lossless decomposition
Pdf of slides??
Are dependency preserving decomposition also lossless ?
Sir 4NF and 5 NF ki video kab aayegi sir
Yeh dono not so important, BCNF tak kaafi hain
11:52 , Sir samaj ni aaya, Arey hame samjaaya hi nahi🤣
Kab taak DECOMPOSITION peserve hongee upto 3rd Normal Form or Boyce Codd Normal Form .
upto 3 hoga.bcnf m kuch b hoskta hai
BCNF tak. Sir ne thora galat bola. BCNF me dependency preserve nhi v ho sakti he.
@@agnimitram340 I think everything depends upon dependency , until it preserves it still decomposed upto B.C.N.F . By the way I have already admitted. 😂😂😂😂😂😂
Upto 3 NF dependency preserve, but after that lossy decomposition because before bcnf rhs is always non prime attribute but in bcnf rhs is prime attribute hence during decomposition we have to seperate the prime attribute for normalisation which leads to lossy decomposition...
Thank you sir