Question

2. Draw an entity relationship diagram (ERD) for the following situation:

The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests.

3. Visit a Web site that allows customers to order a product over the Web (e.g., Amazon.com). Create a data model that the site needs to support its business process. Include entities to show what types of information the site needs. Include attributes to represent the type of information the site uses and creates. Finally, draw relationships, making assumptions about how the entities are related.

Answer 1

Solution:

Entity Relationship diagram:

Explanation:

Entity: There are three entity present in the entity relationship diagram. Which are

named as Researcher, Institute, and Researcher_Interest.

Attributes: In the figure, the ovals represent the attributes of the entity. The underlined

attributes are called primary key of the table entity.

Relationship: Rhombus are used to tell the relationship between the entities.

1: 1 Relationship: Since each researcher can work in only one institute, therefore, the

relationship between researcher and institute is one to one.

1: n Relationship: since one researcher can work more than one research topic, therefore

the relationship between researcher and researcher_interest is one to many.

note: If you do not get anything in this solution, please put a comment and I will help you out.
if you are satisfied, please give me a LIKE if possible.