Part III. Analytical Part 2

1. Please think about the following ER diagram for scenario below. It is true or false? Why? Please use your words to explain this diagram, at least 50 words. In the ER diagram, it should show all the entities along with their attributes and the relationship between entities. Primary keys should be identified and appropriately highlighted.

The Campus Police needs a database to keep track of crimes on campus. They want to store information about various crimes committed on campus. Each crime is identified by a CrimeId. The Date, Time, and a Description of the crime are also recorded. Campus police also stores information about the location where a crime occurred. Locations are identified by LocID. The Address and a map location (MapLoc) are also stored to identify the spot. A crime is associated with one location, but one location can have more than one crime. Crimes are classified by their type. Each class of crime is identified by a TypeID and a Description of that type of crime. The campus Police also store information about suspects. Suspects are identified by an ID. The Name, Address, phone number (PhoneNO) of the suspect is also stored. Whenever a person is suspected to have committed a crime, a numerical rating to represent the level of suspicion (Suspicion_Level) is also recorded. Of course, a crime may have many suspects, and one person may be a suspect in more than one crime.

Crime Type TypeID Description Belongs to Crime Crimeld Date occurs at Location Time + Loc!D Description LocID Typeld Address MapLOC Suspect SuspectID Name Address PhoneNo Crime Suspect CrimelD SuspectID SuspicionLevel