Hey... It's very simple... A relation which has only two attributes is known as Binary Relation. So all the relations in the decomposition set are binary & thus in BCNF.
Hi @All About GATE Exam , thanks for answering so fast! I have already watched the video that you have mentioned but i don't know if i have understood correctly the explanation. For example in this exercise, what happen if i start finding the minimal cover which in this case is F = { A -> C; C-> D; D -> E }. I got the same conclusion as you that my decomposition is D = { AC, CD, DE, AB }. But how do you know that it's a binary relation? As you have said (a relation which has only two attributes is known as Binary Relation), but in this case, what are those two attributes. Is it because my superkey is AB? In which case from your video th-cam.com/video/39cMlcze-GM/w-d-xo.html I am in. Third case?
@@dacioalvirac.6117 All relations in the decomposition set D has only two attributes.. for example AC, it has just two attributes A & C, so relation AC is binary relation. Likewise all relations are binary in decomposition set D. Hope it gets clear now.
@Beyrip Hey can you plz check these videos out th-cam.com/video/E3IFAljC63o/w-d-xo.html & th-cam.com/video/sCaeLe6Z2D8/w-d-xo.html There is an explanation with real time example of various relations.
What do you mean by Plus technique? If you are talking about Closure property or anything plz go through the playlist, each & everything about decomposition is included in detail with example.
Because we can not afford the loss of data in any case. We are decomposing the tables so that anomalies can be removed yet it should be decomposed in such a manner that we get all the data whenever we want to join the decomposed tables back in future .
I hope it's clear, if not ask again exactly where the doubt is... If you are doubtful Abt what is lossless join and all.. go through the decomposition properties th-cam.com/video/1YVr-MmZRU0/w-d-xo.html 👍
Mam plz protest Dear All, It has been an unfortunate time since a couple of years, that vacancies are declared, money is received from the candidates and then they are made to feel miserable for the money they paid, for the hard work they did, and the dedication they showed towards their duty of studying. Some left their homes, some were unsure about How to repay the loans but somehow managing the Studies, but meanwhile, the Selection Comissions are having a gala time. इनके पास हर तरह के बहाने हैं, जैसी स्थिति वैसा बहाना तैयार । कभी exam नहीं होतें हैं तो कभी सालों साल result नहीं आते हैं। हमारे समाज में एक तरफ हम बात करते हैं सरकारी नौकरी, ऊँचे पद और रुतबे की, जिसके लिए हम दिन रात मेहनत करते हैं, वहीं दूसरी तरफ ऐसी जगह पर पहुँचे हुए लोगों का जब आज काम देख रहे हैं, तो लगता हैं, हम पहले ही उनसे कितने बेहतर हैं। जैसे Railway SSC के रुझान हैं, उन्हे देख कर एक साल में 2 बार CET वाला लॉलीपॉप भी क्यों दिया जा रहा है, कुछ हद तक समझा जा सकता है। क्या CET भी महज एक जरिया है जिस से साल में 2 बार ओर एक बेरोजगार की जेब से पैसा निकाला जायेगा? Selection commisions और बेरोजगारी से लड़ते छात्रो के लिए क्या ये एक और पहेली है जिसमे बस छात्र हाथ में एक certificate पकड़ के उलझा रहेगा? We need to stand together in this time, when no media would come for our cause of justice, for the hardwork that we all, teachers as well as students do. There is no politics involved here, yet things are messed up due to negligence of recruitment agencies, biased media and lack of government interest in youth education and employment. Today's matter is not just limited to one or two exams, it's about the system. We all are educated, and if we remain silent at this time, then we don't need to find another culprit for what is happening in the recruitment processes. "INJUSTICE ANYWHERE IS A THREAT TO JUSTICE EVERYWHERE" Please tweet, post on FB, insta, and share everywhere so that this matter is addressed ASAP by the government and students get justice. #SSCDeclareCGLResult #SpeakUpForSSCRailwayStudents #boycottMedia जय हिंद, जय भारत! -Sandeep Jyani
Sis how ur saying AB->C is functional dependence bcoz AB is prime attributes which is part of candidate keys and C is non prime attributes then the relation partial dependence?
@Tejeswini S AB->C is a good functional dependency because AB is Candidate key, not only part of key. Here you understood it right that A & B are key attributes, only thing you need to understand is they are not only part of candidate key but together they make a candidate key. For partial dependency, determinant is only part of candidate key not complete key. I hope you understood... Feel free to ask anymore questions . 👍
Thank you for helping the students with your structured,clear and for the detailed explanation .
Thankyou !!
Hello, how are you? I have a doubt in the minute 10:47, how do you know that your decomposition it's a binary relation?
Hey... It's very simple... A relation which has only two attributes is known as Binary Relation. So all the relations in the decomposition set are binary & thus in BCNF.
Watch this video... th-cam.com/video/39cMlcze-GM/w-d-xo.html
It would help.
Hi @All About GATE Exam , thanks for answering so fast! I have already watched the video that you have mentioned but i don't know if i have understood correctly the explanation. For example in this exercise, what happen if i start finding the minimal cover which in this case is F = { A -> C; C-> D; D -> E }. I got the same conclusion as you that my decomposition is D = { AC, CD, DE, AB }. But how do you know that it's a binary relation? As you have said (a relation which has only two attributes is known as Binary Relation), but in this case, what are those two attributes. Is it because my superkey is AB? In which case from your video th-cam.com/video/39cMlcze-GM/w-d-xo.html I am in. Third case?
@@allaboutcse Those 2 attributes are AC and AB from my descomposition?
@@dacioalvirac.6117 All relations in the decomposition set D has only two attributes.. for example AC, it has just two attributes A & C, so relation AC is binary relation. Likewise all relations are binary in decomposition set D.
Hope it gets clear now.
Plz make a video on this. As a teacher & as a student plz support this movement Mam.
mam can you make a video with using the word like Employee , purchase kind of this i got some confusion when this kind of question come
@Beyrip Hey can you plz check these videos out th-cam.com/video/E3IFAljC63o/w-d-xo.html & th-cam.com/video/sCaeLe6Z2D8/w-d-xo.html
There is an explanation with real time example of various relations.
Can you make a video on the plus technique in decomposition
What do you mean by Plus technique? If you are talking about Closure property or anything plz go through the playlist, each & everything about decomposition is included in detail with example.
finalyy understood!!
Good to know that. 😊
Why are we doing lossless join here
Because we can not afford the loss of data in any case. We are decomposing the tables so that anomalies can be removed yet it should be decomposed in such a manner that we get all the data whenever we want to join the decomposed tables back in future .
I hope it's clear, if not ask again exactly where the doubt is... If you are doubtful Abt what is lossless join and all.. go through the decomposition properties th-cam.com/video/1YVr-MmZRU0/w-d-xo.html
👍
Mam plz protest
Dear All,
It has been an unfortunate time since a couple of years, that vacancies are declared, money is received from the candidates and then they are made to feel miserable for the money they paid, for the hard work they did, and the dedication they showed towards their duty of studying.
Some left their homes, some were unsure about How to repay the loans but somehow managing the Studies, but meanwhile, the Selection Comissions are having a gala time.
इनके पास हर तरह के बहाने हैं, जैसी स्थिति वैसा बहाना तैयार । कभी exam नहीं होतें हैं तो कभी सालों साल result नहीं आते हैं।
हमारे समाज में एक तरफ हम बात करते हैं सरकारी नौकरी, ऊँचे पद और रुतबे की, जिसके लिए हम दिन रात मेहनत करते हैं, वहीं दूसरी तरफ ऐसी जगह पर पहुँचे हुए लोगों का जब आज काम देख रहे हैं, तो लगता हैं, हम पहले ही उनसे कितने बेहतर हैं।
जैसे Railway SSC के रुझान हैं, उन्हे देख कर एक साल में 2 बार CET वाला लॉलीपॉप भी क्यों दिया जा रहा है, कुछ हद तक समझा जा सकता है। क्या CET भी महज एक जरिया है जिस से साल में 2 बार ओर एक बेरोजगार की जेब से पैसा निकाला जायेगा? Selection commisions और बेरोजगारी से लड़ते छात्रो के लिए क्या ये एक और पहेली है जिसमे बस छात्र हाथ में एक certificate पकड़ के उलझा रहेगा?
We need to stand together in this time, when no media would come for our cause of justice, for the hardwork that we all, teachers as well as students do. There is no politics involved here, yet things are messed up due to negligence of recruitment agencies, biased media and lack of government interest in youth education and employment.
Today's matter is not just limited to one or two exams, it's about the system. We all are educated, and if we remain silent at this time, then we don't need to find another culprit for what is happening in the recruitment processes.
"INJUSTICE ANYWHERE IS A THREAT TO JUSTICE EVERYWHERE"
Please tweet, post on FB, insta, and share everywhere so that this matter is addressed ASAP by the government and students get justice.
#SSCDeclareCGLResult #SpeakUpForSSCRailwayStudents
#boycottMedia
जय हिंद, जय भारत!
-Sandeep Jyani
Ma'am.... Upload a video on Relational Algebra
Ma'am ur explaination cleared all our doubts...thank you ma'am ❤️❤️
My pleasure 😊
Ma'am please make a playlist
Here it is DBMS-Database Management Systems: th-cam.com/play/PLlrGO1oauwy45vSJRJQ1ygRT0zYjVMkDH.html 👍😊
Sis how ur saying AB->C is functional dependence bcoz AB is prime attributes which is part of candidate keys and C is non prime attributes then the relation partial dependence?
@Tejeswini S AB->C is a good functional dependency because AB is Candidate key, not only part of key.
Here you understood it right that A & B are key attributes, only thing you need to understand is they are not only part of candidate key but together they make a candidate key.
For partial dependency, determinant is only part of candidate key not complete key. I hope you understood... Feel free to ask anymore questions . 👍
Thank u sis 👍
@@tejeswinis9479 most welcome 🤗
Thanks
Welcome!!
Mam ❤️ u fav from today
Thanks a lot 😊
@@allaboutcse it's my pleasure
Ys
Abe Bhai kuch smjh nhi aya 😶
Koi ni dubara dekh lo 🙂