DBMS - ER Notation & Relationship

What is the purpose of a composite attribute in an ER Diagram?

• It represents a key attribute.

• It is a combination of multiple attributes.

• It indicates a weak entity.

• It simplifies database design.

Which of the following is not a type of relationship in ER Diagrams?

• One-to-One

• Many-to-All

• One-to-Many

• Many-to-Many

What does a double oval represent in an ER Diagram?

• Weak entity

• Strong entity

• Multivalued attribute

• Composite attribute

In ER notation, what does a double rectangle represent?

• Weak relationship

• Weak entity

• Strong relationship

• Strong entity

What is the purpose of cardinality constraints in ER Diagrams?

• To define data types

• To specify the number of instances an entity can be related to another entity

• To enforce referential integrity

• To eliminate redundancy

How is a ternary relationship represented in an ER Diagram?

• With a triple line connecting entities

• With a dashed line

• With a diamond connected to three entities

• With a double line

What does a double diamond represent in an ER Diagram?

• One-to-One relationship

• One-to-Many relationship

• Many-to-Many relationship

• Weak entity

What is the purpose of a surrogate key in a database?

• To uniquely identify records

• To establish relationships between tables

• To improve query performance

• To define primary relationships

In ER Diagrams, what does a dotted line indicate?

• An optional attribute

• A derived attribute

• A weak relationship

• A composite key

What does ER stand for in the context of databases?

• Entity Relational

• Entity Relationship

• Efficient Relationships

• Effective Retrieval