Instructions: The best way to learn about database models is to actually create one. Let$$s create a database model for the end of chapter exercise D$-2$ on page $195($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 as sociated with only one institution, and each researcher has several research interests.$)$

Since we do not have access to a specialized drawing tool, I would like you to draw a data model by hand for this exercise using the notation presented in chapter $5.$ You can then take a picture of your completed data model and attach it as part of the assignment. Here are the instructions on how to complete this assignment.

Step $1)$ Draw the data model $($ERD$)$ for the described scenario in exercise D$-2$ on page $195($using Crow$$s Foot notation for cardinalities as shown in the diagrams in the book$).(70$ points$)$

Hint:

$$ 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 $2)$ In your own words, describe the relationships between these entities in your model. For example, let$$s describe the relationship between Institution and Researcher; here how I would describe it$...$One institution can employ many researchers, but each researcher can be employed by $($or associated with$)$ only one institution. $(30$ points$)$

Bonus: Include modalities of the relationships in your diagram $($under Step $1)$ and describe them accordingly in your write up $($step $2).(10$ points$)$

Submission: Once completed, please submit a hand drawn picture of your data model $($from Step $1)$ along with the write up section $($Step $2)$ as one MS Word file to the Assignment $4$ interface in Blackboard.