ER Diagram Quiz

What does "ER" in ER Diagram stand for?

• Entity Retrieval

• Entity Relationship

• Easy Relation

• Entity Ranking

What is an entity in an ERD?

• A column

• A row

• A real-world object to store data about

• A symbol

Which of the following best represents an attribute in an ERD?

• Rectangle

• Diamond

• Oval

• Line

What symbol is used to represent a relationship in Chen notation?

• Rectangle

• Diamond

• Ellipse

• Square

Which is an example of a multivalued attribute?

• Name

• Phone Number (multiple numbers per person)

• ID

• Age

Which type of attribute can be broken down into smaller parts?

• Derived

• Composite

• Multivalued

• Key

What is the purpose of a primary key?

• To decorate the ERD

• To link attributes

• To uniquely identify each record

• To store multiple values

What is a derived attribute?

• Stored directly

• Stored temporarily

• Calculated from another attribute

• Used as a primary key

In Crow’s Foot notation, what does the three-pronged foot mean?

• One

• Many

• Optional

• None

Which relationship type means each entity instance is linked to just one other?

• One-to-one

• One-to-many

• Many-to-many

• Optional