(6:25) In the 2NF table gets separated, but there in the employee details table the employee code attribute has redundancy but you mentioned it as 2NF.
Good teaching . I have one doubt neega kuduthrukura example la employee code 101 nu two times varalaama..? Bcoz emp code apdinaa its unique ( primary key) ...? Can someone clarify this ? 11:03
In the 3NF In the 1st table Ecode determine Ename then Ename determine Ezipcode then Ecode transitively determine Ezipcode so there is transitive dependency,,, then how you can say it's a 3NF😮
Bro BCNF example la project leader is not a superkey right? There can be multiple persons with the same name la? Apo the example technically satisfies BCNF🤔
In this example, the Project Leader is not a super key. It can also be uniquely determined by only with the Project ID. Therefore, the Project ID alone is sufficient to find the Project Leader. To ensure compliance with BCNF, we'll separate this table into distinct tables.
ANNA ......BEST DBMS EXPLAINATION IN TAMIL ....VERA MARI NEENGA .......NALIKU NA SEM LA NALLA PANA ALL CREDITS GOES TO YOU
Yanakum tmrw sem bro all the best❤❤❤
Epdi bro panniga
Ennaku inaiku exam unga video enaku romba help uh irunthuchi thank you so much
Bro .. ppt yum download panra maari kudunga bro .. will be very useful !!
Really awesome bro 👍
Vera level teaching sir👍💚
Thanks bro Naaliki Semester unghala indha topic super uh purunjidhu 🙌💯.
Best explaination bro thank you
thank you for your effort
Your explanation is easy to understanding
Very Useful!!!
😍🤩
Super explanation
(6:25) In the 2NF table gets separated, but there in the employee details table the employee code attribute has redundancy but you mentioned it as 2NF.
Excellent explanation
Thank u ❤️
Thank you so much anna i understood ❤🇱🇰
Anna, very clear explanation 🎉🎉🎉🎉🎉🎉
Thank you so much Sir❤
9:43 la 101 ku project leader name 1,2 nd tuple ku same aaka thaane varanum.....example la
Good teaching . I have one doubt neega kuduthrukura example la employee code 101 nu two times varalaama..? Bcoz emp code apdinaa its unique ( primary key) ...? Can someone clarify this ? 11:03
I think the same person is working for two projects it is acording to 1nf
Bro eappidi nenga ithu atha determine panuthunu solringa?
3.27 next row ku kondu pona apo redundancy varumla
Second normal form puriyala...but good teaching...I just prepared it for my seminar.. thank you ❤❤❤
.
In the 3NF
In the 1st table
Ecode determine Ename then Ename determine Ezipcode then Ecode transitively determine Ezipcode so there is transitive dependency,,, then how you can say it's a 3NF😮
no bro ename doesnot determine ezip code
👍👍
Very good keep it up❤️
Bro onum illa keys ilam first padichitu varunum apotha purium
Bro sql lab related content video upload pannuga bro
Ok✨👍
Bro BCNF example la project leader is not a superkey right? There can be multiple persons with the same name la? Apo the example technically satisfies BCNF🤔
In this example, the Project Leader is not a super key. It can also be uniquely determined by only with the Project ID. Therefore, the Project ID alone is sufficient to find the Project Leader. To ensure compliance with BCNF, we'll separate this table into distinct tables.
Bcnf oru example soningala !! Athu 2nf a thandum potha appudi marirum !!!
Oah . Iam the first viwers.
And iam watching your videos as an undergraduate.
😊❣️
Nice bro thanks ❤
Well teaching vro.. keep continue
❣️😇
Ppt venum na
Bro 4nf 5nf bro
Will upload soon
Kevalamana explanation onnume puriyala
Appo poi saavu da
Poi firstlarundu start Pannu🤣🤣-palvadi to college😂😂.puriyala na soota moodinu kelambu da tharkuri😹😹
@@Troller_black😂
😂😂
Ivanga dha super ah explain panranga ... ungluku understand panika therila bro.......start to end 🔚 super explanation
Super explanation bro🔥🔥👌
Heyyyyy✨️