Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to make an ER Diagram from the info below. I included a few of the rows to give context to what the columns
I need to make an ER Diagram from the info below. I included a few of the rows to give context to what the columns represent.
Record ID | Agency Code | Agency Name | Agency Type | City | State | Year | Month | Incident | Crime Type | Crime Solved | Victim Sex | Victim Age | Victim Race | Victim Ethnicity | Perpetrator Sex | Perpetrator Age | Perpetrator Race | Perpetrator Ethnicity | Relationship | Weapon | Victim Count | Perpetrator Count | Record Source | |
1 | AK00101 | Anchorage | Municipal Police | Anchorage | Alaska | 1980 | January | 1 | Murder or Manslaughter | Yes | Male | 14 | Native American/Alaska Native | Unknown | Male | 15 | Native American/Alaska Native | Unknown | Acquaintance | Blunt Object | 0 | 0 | FBI | |
2 | AK00101 | Anchorage | Municipal Police | Anchorage | Alaska | 1980 | March | 1 | Murder or Manslaughter | Yes | Male | 43 | White | Unknown | Male | 42 | White | Unknown | Acquaintance | Strangulation | 0 | 0 | FBI | |
3 | AK00101 | Anchorage | Municipal Police | Anchorage | Alaska | 1980 | March | 2 | Murder or Manslaughter | No | Female | 30 | Native American/Alaska Native | Unknown | Unknown | 0 | Unknown | Unknown | Unknown | Unknown | 0 | 0 | FBI |
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