Hello mam.. I have a 3 year's of experience in telecom but now i am switching carrier in database just completed sql and now learning pl sql Please let me know how this knowledge will useful to get a job in MNC
15:04 ma'am agar aisa ho ki ek jagah se kaam krne waale bahut employees hain to agar hame zip code update krna pada to hame unn saare employees k rows me wo zip code update krna padega chahe ham relation ko decompose kyu na kar lein..to ye updation anomaly ko kaise resolve kr rha hai?
Wrong definition your are describing about 1NF => you are saying about atomicity but this is related to data characteristic, The 1NF is describing that the selection of candidate key/column in entity ,it should be unique and self describing . Example- Employee (name, age, address, dateofBirth, accountNo,bankName) . here we can not include bank related column which is not describing Employee. Please rectify your concept then give lecture .Thanks.
I really appreciate your comment, but if you are not clear then check other websites , books and other videos. 1NF has nothing to do with key concepts. You can refer any website you want Bcz definition of 1NF what I have covered is correct. Don't creat confusion in comment box. If you really have doubt then first read about that then mail me I will try to help you out ...
@@TechieLifestyle You are again saying in 1NF is not about key but the definition of 1NF is => The all candidate key should be simple and no prime attribute existing in a relation i.e. table. 👍
beginnersbook.com/2015/05/normalization-in-dbms/ www.javatpoint.com/dbms-first-normal-form www.google.com/amp/s/www.geeksforgeeks.org/first-normal-form-1nf/amp/ www.guru99.com/database-normalization.html My intention of sharing all article is not to argue but to help you out, in case you didn't get me... Anyways you do not need to watch this v if you think your concepts are already cleared.
I didn't find on RUclips a programming lecture like in that kind of easy wording . lots of respect and thanks you mam. from Pakistan
You explained so simply.
Got it in once.
Thanks Mam.
Your language is quite simple to understand
Thanks for your Effort to make me understand easier.
Hello mam..
I have a 3 year's of experience in telecom but now i am switching carrier in database just completed sql and now learning pl sql
Please let me know how this knowledge will useful to get a job in MNC
Could u give an example of a non prime attribute functionally depending on the entire candidate key? Thanks
@TechieLifestyle
where is teacher table 3rd NF?
Thank you very much Ma'am for this informative video.
Explained with clarity, 👍, thanks.
15:04 ma'am agar aisa ho ki ek jagah se kaam krne waale bahut employees hain to agar hame zip code update krna pada to hame unn saare employees k rows me wo zip code update krna padega chahe ham relation ko decompose kyu na kar lein..to ye updation anomaly ko kaise resolve kr rha hai?
Awesome.....i like your way of explaination.....and I'm totally understand and clear my all doubts....thanks a lot 😘
😘??????
Mam you change table between explanation how we can understand consent, which table you apply 3nf
Really ur video is very useful for me
Thanks...❤
amazing tutorial ...very gud way of explaining
i like the way you explain but i want to see your appearance when you're teaching.
1nf, 2nf , 3nf me diffrance ka ak video ba dijiea
how zip code is non prime attribute??
it can be primary key, hence it is a candidate key, hence we can call it prime attribute!!???? please explain
very good explanation 👍
👍
thanks for video mam
HI I Want traning on dbms
mam didn"t get 2nf,3nf
First see what is candidate key ....👍
Wrong definition your are describing about 1NF => you are saying about atomicity but this is related to data characteristic, The 1NF is describing that the selection of candidate key/column in entity ,it should be unique and self describing .
Example- Employee (name, age, address, dateofBirth, accountNo,bankName) . here we can not include bank related column which is not describing Employee. Please rectify your concept then give lecture .Thanks.
I really appreciate your comment, but if you are not clear then check other websites , books and other videos. 1NF has nothing to do with key concepts.
You can refer any website you want
Bcz definition of 1NF what I have covered is correct.
Don't creat confusion in comment box.
If you really have doubt then first read about that then mail me I will try to help you out ...
@@TechieLifestyle You are again saying in 1NF is not about key but the definition of 1NF is => The all candidate key should be simple and no prime attribute existing in a relation i.e. table. 👍
beginnersbook.com/2015/05/normalization-in-dbms/
www.javatpoint.com/dbms-first-normal-form
www.google.com/amp/s/www.geeksforgeeks.org/first-normal-form-1nf/amp/
www.guru99.com/database-normalization.html
My intention of sharing all article is not to argue but to help you out, in case you didn't get me...
Anyways you do not need to watch this v if you think your concepts are already cleared.
@@TechieLifestyle hhahah right mam , if your concept is already clear then why you are here.
@@TechieLifestyle yes you're absolutely right, yeh amit stupid hai tum ignore kro isse.
mam pahle aap deciede kr lo hindi mai btaogi ya english mai
Its hectic
ek hi video ma sab describe kar, jaa ke dusra video dekhne keliya matt bol