Sorry Farhan Sir.. ❤️🥀 কিছু মনে করবেন না, এখানে আপনি একটা ভুল কথা বললেন Sir..😊 Non key Attributes এর ওপরে Key Attributes কোনোদিনই dependent হয়না Sir .. 😊😊 যতদুর জানি, Key Attributes এর ওপরে Non Key Attributes dependent হয়।। সেটা যেই কোনো dependency তেই।।😊😊.. আমি কলকাতা থেকে বলছি, একজন ভারতীয় নাগরিক Sir.. 😊
Ji, key attributes kkhonoi non key attributes er upore dependent hobe na, but for the above example these scenarios exist that's why we need to convert it as BCNF. So what is discussed in the video is fine. Please follow the video again I hope you will understand.
kono table jdi key attribute depend hoi non key attribute tahle anomaly problem hbe ,ar BCNF e rules ache anomaly prblm hbe na tai uni jkhn table ta vanglo ar anomaly prblm ta hlo na tai uni thik prieche
nice, i finally understand bcnf ! thanks so much man, this is the only video that helped me
Superb Farhan brother.... Keep going brother.... ❤️
Thanks a lot brother ❤️
Thanks so much vai.
etai ki 3.5 NF??
Where does this series end?
course kivbe pk hoi? ekhne to data repetition ase and amra jani j key howar jnno uniqueness thakte hbe, tahole kivbe hbe?
multiple primary key thakle data repetition hote pare.
but oi 2ta primary key er data ekshate repeat hote parbe na.
| std_id | course | instructor |
| 101 | C | Farhan |
| 102 | Java | Hossan |
| 101 | Java | Jisan |
ekhane 101 & java repeat hoyece kintu row wise same data repeat hoy nai. tai eita possible.
| std_id | course | instructor |
| 101 | C | Farhan |
| 102 | Java | Hossan |
| 101 | C | Jisan |
ekhane 101 & C ekshate repeat hoyece tai eita possible na.
Sorry Farhan Sir.. ❤️🥀
কিছু মনে করবেন না, এখানে আপনি একটা ভুল কথা বললেন Sir..😊
Non key Attributes এর ওপরে Key Attributes কোনোদিনই dependent হয়না Sir .. 😊😊 যতদুর জানি, Key Attributes এর ওপরে Non Key Attributes dependent হয়।। সেটা যেই কোনো dependency তেই।।😊😊..
আমি কলকাতা থেকে বলছি, একজন ভারতীয় নাগরিক Sir.. 😊
Ji, key attributes kkhonoi non key attributes er upore dependent hobe na, but for the above example these scenarios exist that's why we need to convert it as BCNF.
So what is discussed in the video is fine.
Please follow the video again I hope you will understand.
kono table jdi key attribute depend hoi non key attribute tahle anomaly problem hbe ,ar BCNF e rules ache anomaly prblm hbe na tai uni jkhn table ta vanglo ar anomaly prblm ta hlo na tai uni thik prieche
Kicu vul ace vaiya.
2nd table a delate anomaly theke gace.