One primary key for 2 entities (ERD)

Question

I am drawing an ERD diagram for a hospital data base system scenario. In the database there are 2 types of doctors, one is a researcher and one is a practitioner. When drawing the ERD, I have created 2 different entities for them, and for the primary key I have given doctorID as the primary key for both the entities.

So my question is, is it possible to have one primary key for 2 entities?

Thank you for your time.

I suggest to give some code samples, too, I makes much easier to understand your question. — peterh, Dec 14 '13 at 16:28

score 2 · Accepted Answer · edited May 23 '17 at 12:19

2

It sounds like what you want is inheritance. You have a base Doctor entity, with the child Researcher and Practitioner types. The primary key is on the base Doctor entity.

This is a very useful post about how you can actually model these in a database: How do you effectively model inheritance in a database?

edited May 23 '17 at 12:19

Community

1
1

answered Dec 14 '13 at 16:39

Paul Coghill

667
6
27

One primary key for 2 entities (ERD)

1 Answers1