Link for my E-R Model (E-R Diagram using Canva): https://www.canva.com/design/DAF7BWjDyho/OEaob53i_DAXX3vnBYq_rw/view?
utm_content=DAF7BWjDyho&utm_campaign=designshare&utm_medium=link&utm_source=e
ditor
The information given defines the makeup of an entity-relationship (E-R) diagram for a City Jail database. In this case, the E-R diagram (model) is the basis for a crime-tracking system. This E-R
diagram includes entities, attributes, and relationships in the city jail database. The E-R diagram is a basically a good layout for tracking criminal activities within city jails. Criminals, crimes, sentencing, appeals, and police officers are all entities. Criminal charges and appeal cases are additional entities forming relationships between different entities. Each of the entities has a set of attributes characterizing and describing the related data. Criminal_ID, Crimes_ID, Sentencing_ID, Appeal_ID, and Officer_ID are all primary keys (these are uses for memo data). I would say, rhis ER model sums up the memo from the City Jail Information Director pretty well as it directly covers up all the details given.
