Question

Database management systems are expected to handle binary relationships but not unary and ternary relationships.'

True or false

Answer 1

The claim that database management systems cannot handle unary and ternary relationships is false; they can manage unary, binary, and ternary relationships as well as other complex relationships.

Step-by-step explanation:

The statement 'Database management systems are expected to handle binary relationships but not unary and ternary relationships.' is false. Modern database management systems (DBMS) are equipped to handle a variety of relationship types, including unary (or recursive), binary, and ternary relationships, among others. A unary relationship is an association between two instances of the same entity. For example, an employee entity might have a manager relationship that relates an employee to another employee who is the manager. A binary relationship exists between two different entities, such as an 'Employee' entity and a 'Department' entity where an employee works in a department. A ternary relationship involves three different entities at the same time, such as a 'Supplier', 'Product', and 'Consumer' entities, where a supplier provides products to a consumer.

Answer 2

False

Database management systems are expected to handle binary, unary and ternary relationships.

Step-by-step explanation:

Unary Relationship: It is a recursive relationship which includes one entity in a relationship which means that there is a relationship between the instances of the same entity. Primary key and foreign key are both the same here. For example a Person is married to only one Person. In this example there is a one-to-one relationship between the same entity i.e. Person.

Binary Relationships: It is a relationship involving two different entities. These two entities identified using two relations and another relation to show relationship between two entities and this relation holds primary keys of both entities and its own primary key is the combination of primary keys of the both relations of the two entities. For example Many Students can read a Book and many Books can be obtained by a Student.

Ternary Relationships: is a relationship involving three entities and can have three tables. For example a Supplier can supply a specific Part of many Mobiles. Or many Suppliers may supply several Parts of many Mobile models.