Degree of relationship type is the number of participating _______

Question

Accepted Answer

The correct option is (2):
The **degree of a relationship type** in a Database Management System (DBMS), particularly within the Entity-Relationship (E-R) model, is a fundamental concept that refers precisely to the number of **Entity types** that participate in that relationship. The degree of a relationship establishes its classification and structural complexity. For instance, a relationship involving only one entity type (e.g., an 'Employee' supervising another 'Employee') is called a Unary relationship (degree 1). The most common type, linking two distinct entity types (e.g., 'Customer' places an 'Order'), is a Binary relationship (degree 2). Any relationship involving *n* entities is an N-ary relationship. Counting the distinct entity types connected to the relationship diamond in an E-R diagram is the direct method for determining its degree, which is crucial for correct logical database design.

The incorrect option is (1), (3), and (4):
The other options describe different structural components of the database model. The term **Keys types** (Option 1) refers to components like Primary Keys and Foreign Keys, whose primary role is to uniquely identify entity instances and enforce referential integrity *across* the relationships, not to define the number of entities involved. **Attribute types** (Option 4) are properties or characteristics that describe either an entity (e.g., 'Name', 'Salary') or a relationship itself, but they do not count the entities participating in the relationship. If you were to count the attributes, you would be determining the *degree of a relation* (i.e., a table's number of columns) in the Relational Model, which is a different concept entirely. Finally, **Condition types** (Option 3) is a general term that, in the context of relationships, might refer to *Cardinality Constraints* (like one-to-many or mandatory participation). These constraints define the *rules* and limits on how many instances of one entity can associate with instances of another, but they are not used to count the total number of distinct entity sets involved.