1Z0-006 Entity-Relationship Modeling Questions and Answers

Question 1

A database designer is creating a model for a university.
The 'PERSON' entity has common attributes like 'PersonID' and 'Name'.
There are also more specific entities like 'STUDENT' (with 'GPA') and 'PROFESSOR' (with 'Salary'). 'STUDENT' and 'PROFESSOR' both inherit the attributes of 'PERSON'.
What is the 'PERSON' entity an example of in this relationship?

Accepted Answer

A supertype entity

Answer

An associative entity

Answer

A subtype entity

Answer

A recursive entity

Question 2

In an Entity-Relationship Diagram, a student's age can be calculated from their 'DateOfBirth' attribute. How would the 'Age' attribute be BEST classified?

Accepted Answer

Derived attribute

Answer

Composite attribute

Answer

Multivalued attribute

Answer

Simple attribute

Question 3

A database for a small company needs to model the relationship where an 'EMPLOYEE' manages other 'EMPLOYEEs'. What type of relationship is this, where an entity has a relationship with itself?

Accepted Answer

A recursive relationship

Answer

A ternary relationship

Answer

An arc relationship

Answer

A binary relationship

Question 4

When modeling a database, you identify a many-to-many relationship between 'STUDENT' and 'COURSE'. To resolve this relationship in the logical model, what should be created?

Accepted Answer

An intersection entity (associative entity)

Answer

A supertype entity

Answer

A recursive relationship

Answer

A foreign key in the 'STUDENT' table

Question 5

Which of the following describes the aspect of a relationship that specifies the minimum number of instances an entity can be associated with in that relationship?

Accepted Answer

Ordinality

Answer

Degree

Answer

Cardinality

Answer

Domain

Question 6

A database designer is creating a table for 'EMPLOYEE' and needs to store their phone numbers. An employee can have multiple phone numbers (e.g., home, mobile, work). Which type of attribute is MOST appropriate for storing the phone numbers?

Accepted Answer

Multivalued attribute

Answer

Composite attribute

Answer

Simple attribute

Answer

Derived attribute