Need help setting up this E-R Model.

Case Study: City Jail Your company receives the following memo. First, based on the memo, creat design (E-R model) for the City Jail that indicates relationships. In developing your design, consider the columns needed to build relationships between the entities. Use only the entities identified in the memo to develop the E-R model. e an initial database entities, attributes (columns), primary keys, and Second, create a list of additional entities or attributes not identified in the memo that might be applicable to a crime-tracking database. TIP Keep in mind that the memo is written from an end-user perspective-not by a database developer MEMO To: Database Consultant From: City Jail Information Director Subject: Establishing a Crime-Tracking Database System It was a pleasure meeting with you last week. I look forward to working with your company to create a much-needed crime-tracking system. As you requested, our project group has outlined the crime-tracking data needs we anticipate. Our goal is to simplify the process of tracking criminal activity and provide a more efficient mechanism for data analysis and reporting. Please review the data needs outlined below and contact me with any questions. Criminals: name, address, phone number, violent offender status (yeso), probation status (yes/ no), and aliases Crimes: classification (felony, misdemeanor, other), date charged, appeal status (closed, can appeal, in appeal), hearing date, appeal cutoff date (always 60 days after the hearing date) arresting officers (can be more than one officer), crime codes (such as burglary, forgery, assault