Chapter 5, Problem 9C

Explanation of Solution

Crow’s Foot ER diagrams for support the need of business:

The following data model shows the solution for the given question.

Explanation:

• In the above data model, the “Person” supertype entity contains “Per_No” as primary key. It contain optional “Author” entity and this entity contain “Per_No” is the primary and foreign key.
• The person has much expertise to work on the particular research and the “Expertise” has “Per_No” and “Int_code” are the primary and foreign keys.
• The “Interest” entity contains “Int_code” as primary key...