Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Instructions: The best way to learn about database models is to actually create one. Lets create a database model for the end of chapter exercise D on page 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 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 Draw the data model ERD for the described scenario in exercise D on page using Crows Foot notation for cardinalities as shown in the diagrams in the book 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 establishdefine 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 In your own words, describe the relationships between these entities in your model. For example, lets describe the relationship between Institution and Researcher; here how I would describe itOne institution can employ many researchers, but each researcher can be employed by or associated with only one institution. points
Bonus: Include modalities of the relationships in your diagram under Step and describe them accordingly in your write up step points
Submission: Once completed, please submit a hand drawn picture of your data model from Step along with the write up section Step as one MS Word file to the Assignment interface in Blackboard.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started