Project 1

For this project, you will create a database for the police department of your city

Please investigate and look what entities are important for your project.

You don’t get any minimum or maximum amount of entities or attributes. My only requirement at the end is that your project is extensive and master level worthy.

You create groups of 2 and will work on every step of the way. You will get feedback from me the days after you have uploaded the part of the project.

At the end my TA will grade the full project and give you your final grade

Project part A

Please list all the entities you think will be important

Describe every entity

Give all the attributes you think each entity should have

Create a priliminary ER diagram like in Chap 4