Create entity relationship diagram for Heritage Consortium? Name entities, attributes, and relations (9 entities with all 1 to many relationships)

Question

The Heritage Consortium, headquartered in Toronto, Canada, helps coordinate cooperation among 50 large government-sponsored museums across North America, South America and Europe....

It wouldn't let me load the entire question, but It's hard for me to understand. Can you please explain it?

Answer 1

Entities:

1. **Heritage Consortium**

- Attributes: Consortium_ID, Consortium_Name, Contact

2. **Member Organization**

- Attributes: Org_ID, Org_Name, Org_Type, Contact

3. **Project**

- Attributes: Project_ID, Project_Name, Dates, Budget

4. **Heritage Site**

- Attributes: Site_ID, Site_Name, Location

5. **Researcher**

- Attributes: Researcher_ID, Name, Contact

6. **Funding Source**

- Attributes: Source_ID, Source_Name

7. **Publication**

- Attributes: Publication_ID, Title, Date, Authors

8. **Artifact**

- Attributes: Artifact_ID, Name, Origin, Date

9. **Membership**

- Attributes: Membership_ID, Joining_Date, Membership_Type

Relationships:

1. Heritage Consortium has **Many** Member Organizations.

- Each Member Organization belongs to **One** Heritage Consortium.

2. Member Organizations can participate in **Many** Projects.

- Each Project is associated with **One** Member Organization as a lead.

3. Projects can be linked to **Many** Heritage Sites.

4. Researchers can be involved in **Many** Projects.

- Each Project can have **Many** Researchers.

5. Funding Sources can fund **Many** Projects.

- Each Project is funded by **One** Funding Source.

6. Researchers can publish **Many** Publications.

- Each Publication is authored by **One or More** Researchers.

7. Artifacts can be featured in **Many** Publications.

- Each Publication can feature **Many** Artifacts.

8. Member Organizations can have **Many** Memberships in the Heritage Consortium.

- Each Membership belongs to **One** Member Organization.

9. The Heritage Consortium can have **Many** Memberships from Member Organizations.

- Each Membership is associated with the One Heritage Consortium.