Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first step of creating data models is to identify the entities. In this scenario there will be three entities: Institution, Researcher, and Research Interests.

The first step of creating data models is to identify the entities. In this scenario there will be three entities: Institution, Researcher, and Research Interests.
The next step is to identify attributes for each entity and assign identifiers. For example, attributes about Institution will include university name, location, enrollment. I would select university name as an identifier as that should be a unique attribute for each record in that table. You will need to determine the attributes and an identifier for Researcher and Research Interests entities. Remember that an identifier can consist of a created id field if you do not have an attribute that is unique for that entity.
Last step is to identify relationships between the entities. You will have a relationship between Institution and Researcher (remember they go both ways so you will also have to establish/define the relationship between Researcher and Institution), and another relationship between Researcher and Research Interest (and vice versa). Please make sure to specify the cardinality for each side of the relationship in your model.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Approaches to Managing Organizations

Answered: 1 week ago

Question

Communicating Organizational Culture

Answered: 1 week ago