Entity Relationship Diagram

What in UML Class Diagram is a CLASS, in ERD Diagram is an ​ (a)   !

What in UML Class Diagram is a ATTRIBUTE, in ERD Diagram is an ​ (b)   !

• ENTITY
• FIELD
• TABLE
• COLUMN
• RELATIONSHIP

What in the tables would represent columns and rows?

a

b

Field/Attribute

Entity

Select what number in tables relationships represent optionality and what number represent cardinality?

a

b

Optionality

Cardinality

On this example relationship of Customer toward Transaction is...

• Optional

• Mandatory

On this example relationship of Transaction toward Customer is...

• Optional

• Mandatory

Match relationship graphic with the correct meaning of that relationship

• Zero or One

• 
• One

• 
• One or Many

• 
• Zero or Many

• 
• Only One

• 

What type of relationship is in this diagram

• one-to-one

• one-to-may

• many-to-many

What type of relationship is in this diagram

• one-to-one

• one-to-may

• many-to-many

What type of relationship is in this diagram

• one-to-one

• one-to-may

• many-to-many

We have two Customer diagrams, one is UML and another one is ERD. Mark them properly!

a

b

ERD Diagram

UML Diagram