Entity-Relationship Modelling Quiz

Which notation uses soft boxes with rounded corners for entities?

• Chen’s Notation

• Crow’s Foot Notation

• Barker’s Notation

• UML Notation

What uniquely identifies an instance of an entity?

• Attribute

• Unique Identifier (UID)

• Relationship

• Optionality

In a many-to-one relationship, the parent entity:

• Must have a crow’s foot symbol

• Must exist before the child entity

• Is optional

• Cannot enforce referential integrity

Which symbol indicates a 'many' degree in Barker’s Notation?

• Solid line

• Dotted line

• Crow’s foot

• Rectangle

What is the purpose of a Unique Identifier (UID)?

• To name relationships

• To distinguish one instance from another

• To define optionality

• To resolve many-to-many relationships

Which relationship type is rare and often indicates merged entities?

• Many-to-many

• One-to-one

• Many-to-one

• Optional

In Barker’s Notation, how are entity names formatted?

• Lowercase

• UPPERCASE

• Italicized

• Bold

What does referential integrity enforce in a parent-child relationship?

• A parent cannot be deleted without deleting its children

• A child can exist independently

• Optionality is ignored

• Relationships are renamed

Which component of a relationship defines 'must' or 'may'?

• Degree

• Optionality

• Name

• Quantified degree

What is an example of an instance of a SCHOOL entity?

• Hard Rock High School

• Student ID

• TeacherName

• Crow’s foot