DBMS | ER Model | Recursive Relationships | Ravindrababu Ravula | Free GATE CS Classes

[@yosingh7479]

Sir I just want to say thank you very very much because of you I managed to clear my TOC subject in engineering.. without you I would have failed badly in that subject and wouldn't have got any campus placement..you are the reason why I am placed in campus interview.....thank you from bottom of my heart..Bhagwan apko sada khush rakhe

[@theversatilesinnovationsnv8950]

the best thing i liked abt ur lecture is that u dont waste time in ur introduction.. nor any other thing.....

[@thirumalasettysaisatish1043]

I think the Deegre is 1 Because only one is participating that is "employee"

[@chrischauhan1649]

As a single entity type is participating in the recursive relationship, the degree of recursive relationship will be 1 and it will be a unary relationship.

[@kawyachandrasekara3959]

Degree is 2 , right?

[@kawyachandrasekara3959]

When it is Mapped in to tables empliyee is one column and supervisee another.And the columns are called degree in tables.It can be 2 tables as well.Since we draw er before creating relevant tables I think the degree is certainly 2.Like we take simple valued attributes of a composite attribute into a table instead of the composite value...

[@soujanyaa490]

I think cardinality of employee(as supervisor) should be N-1 ???? isn't it so?

[@arahflorgallardo871]

why is the participation of of Employee(as supervisor ) zero? I assumed that the entity type on the left side would supervise the Employee(as supervisee). Why is the 'bottom level employee' considered at the entity type Employee(as supervisor)? I'm confused btw, Thank you very much Sir

[@Haiderali-hi5cj]

sir you are hero. appreciating you hardwork and teaching technique. wish we have professor like u in our colleges.

[@palakjain2505]

Aren't recursive relationships unary?

[@luckykaul08]

sir u said there is only entity then i am confused why is the degree is 2 then ......

[@bikerrogue303]

2 entities from the same entity type thats y

[@shasanlearning1975]

since e1 does not have realtionship with e1itself as mention in the lecture, that's why its a binary relationship and therefore degree going to be 2.

[@pushpakkakani9080]

lucky kaul : similar doubt...

[@kuelf123]

I think RBR uploads his videos slightly slowed down, or he is just a really slow talker. At 1.5x speed he speaks clearly.

[@gopalg7047]

Why the degree is 2 even it has only one entity and why the cardinality of supervisor is N,why cant be N-1

[@tharinisirimanna1898]

Explained well...Is there any video related for mapping recursive relationships in to relational schema model from ER diagram?

[@saajidhnawwar8505]

sir how to represent this in a relational model?

[@flamelsphoenix145]

Please add automatic subtitle

[@Pvsmounish]

Isn't the cardinality ratio for employee (as supervisor) is N-1? As he can't supervise himself.

[@creamice5755]

It is a best tutorial.

[@hauteswan2541]

Thanks.

[@TheAjmeri]

Sir, I have confusion. How it could be binary relationship because there are only one entity employee , I am your big fan , Thanks for the great videos!

[@dhivyakamalakannan]

The degree is two because in every relationship, there are two entities that are interacting. I think you are getting confused between the concepts of entity type and entity. Employee is the entity type.. and e1, e2, e3, etc.. are the entities.. Hope this clears your doubt.

[@sharmilashankar2245]

+Dhivya Kamalakannan Thank you so much... Even i came across the same doubt :)

[@dhivyakamalakannan]

You are very welcome Sharmila ! :)

[@sonalihiranandani965]

hey there ..But there is still confusion ..bcz every book/website every possible stuff is considering recursive relationship to be unary! Totally confused.

[@rakeshmarikanti1030]

sir, told that degree is no.of entities participating in that bt here the entities are same na then how can we said that it is two

[@antakho76]

Sir please upload c++ videos

[@AnkitaYadav-qp4wn]

#CFBR

[@unisasankarakamara6058]

Hello guyz, iv'e a work to present on Thursday and I don't have knowledge in database systems,can some one help me please. Thanks in advance.