Unit 4 Long Test (BSIT 2A Irreg)

What does the degree of a relationship in an ER model represent?

• The number of instances in an entity

• The number of participating entities in a relationship

• The cardinality of a relationship

• The normalization of a relationship

Which degree involves a single entity related to itself?

• Binary

• Higher-Degree

• Ternary

• Unary

What is another term for a unary relationship?

• One-to-one relationship

• Recursive relationship

• Multi-entity relationship

• Self-similar relationship

Which of the following is the most common degree in database design?

• Unary

• Binary

• Ternary

• Higher-Degree

Which example best represents a ternary relationship?

• An employee supervising other employees

• A student enrolling in a course taught by a specific instructor

• A customer placing an order for products

• A supplier providing products to a warehouse

What happens when higher-degree relationships are normalized?

• They are split into multiple unary relationships

• They are decomposed into binary relationships

• They are transformed into ternary relationships

• They become recursive relationships

In the context of degree and cardinality, what does cardinality describe?

• The number of participating entities

• The complexity of the relationship

• The number of instances in one entity associated with another entity

• The type of relationship (e.g., unary, binary)

Why are higher-degree relationships generally avoided?

• They are difficult to diagram

• They increase database complexity and reduce maintainability

• They cannot represent real-world scenarios

• They do not support cardinality constraints

What is an example of a binary relationship?

• A doctor treating multiple patients in a hospital

• A teacher teaching many courses

• An employee supervising other employees

• A supplier providing products to specific warehouses

What is the main advantage of higher-degree relationships?

• They are easier to maintain in a database

• They represent complex real-world scenarios directly

• They simplify database queries

• They reduce the need for normalization