Assignment requirements: First, based on the memo, create an initial database design (E-R model) for the city jail that indicates entities, attributes (columns), primary keys, and relationships...

Assignment requirements:
 First, based on the memo, create an initial database design (E-R model) for the city jail that indicates entities, attributes (columns), primary keys, and relationships between the entities. Use only the entities identified in the memo to develop the E-R model.    Second, create a list of additional entries or attributes not identified in the memo that might be applicable to a crime-tracking database.  Furthermore, normalize your database design to 3NF so that it is ready to be deployed to Oracle12c SQL developer.
Report structure and assignment submission:
1. Content of your report a. Prepare a report which will detail an E-R diagram (I need softcopy of it) and justification your choice of entities and attributes. b. Detail the normalization process of the ER diagram in details. c. Describe each additional entries or attributes you have created and why? d. Write down all the assumptions you have considered while preparing the ER diagram.