Chapter 2 Databases - ERD

What entity name is used in the given diagram?

• STUDENT
• DOCTOR
• EMPLOYEE
• COURSE

Which attribute is the MULTI-VALUED ATTRIBUTE?

• EmpID
• Degree
• Age
• Address

Which attribute is the COMPOSITE ATTRIBUTE?

• Degree

• Age

• Salary

• Address

Which attribute is the DERIVED ATTRIBUTE?

• EmpID
• Age
• Name
• Degree

Which attribute is the KEY IDENTIFIER or the PRIMARY KEY?

• EmpID
• Degree
• Name
• Birthday

This symbol indicates _____ relationship.

• one or many
• zero or many
• zero or one
• many to many

This symbol indicates _____ relationship.

• zero or one
  zero or one
• zero or many
• one or many
• many to many

This is a relationship type that involves only one entity type.

• Unary
• Binary
• Ternary
• None of these

_________is a person, place, object, event or concept in the user environment about which company wishes to maintain the data

• attribute
• entity
• relationship
• none of these

Each entity is described by __________.

• entity
• relationship
• attribute
• none of these