Draw an entity relationship diagram (ERD) for the following situations. Would the relationships be identifying or nonidentifying? Why?

1. Doctor's office - as the Doctor entity is an independent entity, (can exist without the Patient entity), this is a non-identifying relationship.

2. Phone - as the Phone Extension entity is an independent entity, (can exist without the Employee entity), this is a non-identifying relationship.

3. Movie theatre - as the Movie entity is an independent entity, (can exist without the Theatre entity), this is a non-identifying relationship.

Transcribed Image Text:

Patient assigned to assigned H Doctor