You are in charge of designing a student internship database to gather and share internship opportunities with students. Please answer the following questions that guide your thinking about the design:

a$.$ What are the entity sets for the database?

b$.$ What would be your suggested essential attributes and the key for each entity set $($attributes do not need to be comprehensive, just the essential ones$)?$

Tip:

If you only have one attribute for your entity set, you need to consider whether it is qualified to be an entity set. It could be just an attribute!

c$.$ What are the relationships among the entity sets and the nature of the relationships in terms of connectivity and participation? Please specify the assumptions$/$business rules for EACH relationship.

d$.$ Draw an E$-$R diagram to reflect your design.

$($Note: the diagram should include all entity sets, attributes, the key specified for each entity set, and all relationships.$)$