homeworkstudyhelp

Our Services

Get 15% Discount on your First Order

Use a Lucid chart to Build a Logical Entity Relationship Diagram…

  1. Use a Lucid chart to Build a Logical Entity Relationship Diagram (ERD) and also Build a Physical ERD based on the data dictionary below.
  2. give at least three references and summary of the work
Field Name in Original SourceField Name in Your DatabaseData TypeShort Description of Data FieldRequired Field?Accepts NULL Value?
ARREST_KEYArrest_KeyIntegerUnique identifier for an arrestYesNo
ARREST_DATEArrest_DateDateDate of the arrestYesNo
PD_CDPD_CDIntegerInternal classification code for NYPD crime classificationYesNo
PD_DESCPD_DescTextDescription of the internal classification code for NYPD crime classificationYesYes
KY_CDKY_CDIntegerThree digit internal classification code for NYPD crime classificationYesNo
OFNS_DESCOFNS_DescTextDescription of the three digit internal classification code for NYPD crime classificationYesYes
LAW_CODELAW_CodeTextLaw code associated with the arrest chargeYesYes
LAW_CAT_CDLAW_Cat_CDTextLevel of offense classification (e.g., felony, misdemeanor, violation)YesYes
ARREST_BOROArrest_BoroTextBorough of the arrestYesYes
ARREST_PRECINCTArrest_PrecinctIntegerPrecinct of the arrestYesNo
JURISDICTION_CODEJurisdiction_CodeTextJurisdiction code associated with the arrest chargeYesYes
AGE_GROUPAge_GroupTextAge group of the person arrestedYesYes
PERP_SEXPerp_SexTextGender of the person arrestedYesYes
PERP_RACEPerp_RaceTextRace of the person arrestedYesYes
X_COORD_CDX_Coord_CDIntegerX-coordinate of the arrest location in the New York State Plane Coordinate SystemYesYes
Y_COORD_CDY_Coord_CDIntegerY-coordinate of the arrest location in the New York State Plane Coordinate SystemYesYes
LatitudeLatitudeDecimalLatitude of the arrest locationYesYes
LongitudeLongitudeDecimalLongitude of the arrest locationYesYes
New Georeferenced ColumnNew_Georeferenced_ColumnTextGeoreferenced data that includes the longitude and latitude of the arrest locationNoYes

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions