- Use a Lucid chart to Build a Logical Entity Relationship Diagram (ERD) and also Build a Physical ERD based on the data dictionary below.
- give at least three references and summary of the work
Field Name in Original Source | Field Name in Your Database | Data Type | Short Description of Data Field | Required Field? | Accepts NULL Value? |
ARREST_KEY | Arrest_Key | Integer | Unique identifier for an arrest | Yes | No |
ARREST_DATE | Arrest_Date | Date | Date of the arrest | Yes | No |
PD_CD | PD_CD | Integer | Internal classification code for NYPD crime classification | Yes | No |
PD_DESC | PD_Desc | Text | Description of the internal classification code for NYPD crime classification | Yes | Yes |
KY_CD | KY_CD | Integer | Three digit internal classification code for NYPD crime classification | Yes | No |
OFNS_DESC | OFNS_Desc | Text | Description of the three digit internal classification code for NYPD crime classification | Yes | Yes |
LAW_CODE | LAW_Code | Text | Law code associated with the arrest charge | Yes | Yes |
LAW_CAT_CD | LAW_Cat_CD | Text | Level of offense classification (e.g., felony, misdemeanor, violation) | Yes | Yes |
ARREST_BORO | Arrest_Boro | Text | Borough of the arrest | Yes | Yes |
ARREST_PRECINCT | Arrest_Precinct | Integer | Precinct of the arrest | Yes | No |
JURISDICTION_CODE | Jurisdiction_Code | Text | Jurisdiction code associated with the arrest charge | Yes | Yes |
AGE_GROUP | Age_Group | Text | Age group of the person arrested | Yes | Yes |
PERP_SEX | Perp_Sex | Text | Gender of the person arrested | Yes | Yes |
PERP_RACE | Perp_Race | Text | Race of the person arrested | Yes | Yes |
X_COORD_CD | X_Coord_CD | Integer | X-coordinate of the arrest location in the New York State Plane Coordinate System | Yes | Yes |
Y_COORD_CD | Y_Coord_CD | Integer | Y-coordinate of the arrest location in the New York State Plane Coordinate System | Yes | Yes |
Latitude | Latitude | Decimal | Latitude of the arrest location | Yes | Yes |
Longitude | Longitude | Decimal | Longitude of the arrest location | Yes | Yes |
New Georeferenced Column | New_Georeferenced_Column | Text | Georeferenced data that includes the longitude and latitude of the arrest location | No | Yes |