What Is Discriminator In Dbms?

2

2 Answers

Akshay Deshmukh Profile
Akshay Deshmukh answered
There is concept of "Strong" and "Weak" entities in RDBMS.  Strong Entity: Attributes of which are able to form Primery key i.e. To form a key which can uniquely identify its member.  Weak Entity: Attributes of which are unable to form Primery key i.e. To form a key which can uniquely identify its member.  Eg.  Consider following relations in  of Computer Engg Department context  relation 1: Class  { Division Name, Class Room No., Class Teacher }  it is Strong Entity as any member can be uniquely identified by its  Division Name, hence it is primery key.    And  relation 1: Student  { Roll No., Name, Attendance }  it is Weak Entity as any member can not be uniquely identified by any attribute or combination of attributes.  As Roll no. Of students in different divisions can be same.    But if we combine "Roll no." with "Division Name" then any member of Student relation can be identified uniquely.  And hence for Student relation "Roll no." is Discriminator.
Broad Kenny Profile
Broad Kenny , Broad Hodge, answered

A strong entity set has a primary key. All tuples in the set are distinguishable by that key. A weak entity set has no primary key unless attributes of the strong entity set on which it depends are included. Tuples in a weak entity set are partitioned according to their relationship with tuples in a strong entity set. Tuples within each partition are distinguishable by a discriminator, which is a set of attributes.

Answer Question

Anonymous